Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Issue with Slicer while combining two columns

Hello all, I am new to PowerBI and am trying to create a view in PowerBI with the help of slicer.   I have a table which has 3 columns namely Title, Primary Author, Secondary Author. I am trying t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Many Thanks for your guidance!!

 

I am facing an issue with the last step. When I try to select the columns and unpivot selected columns, it's creating two columns namely "Attribute" and "Values" and "Error" is filled in all the rows.. 

I tried to unpivot by selecting a)only the primary and secondary authors columns b) selecting title and authors columns. both are not working. 

 

could you please shed some light on what am I missing?

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

Ok Anonymous . I got "Attribute" column too but I removed it (I forgot to mention this last step, sorry about that)

Have you checked that all the values are text? To unpivot just select option a), never the title

I assume you have reached this point without error, isn't it?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    No luck!! 😞 Will it not work if there are rows with "null" values?? 

    I am able to split the columns based on delimiter but unable to unpivot and get the desired output...

    • mlsx4's avatar
      mlsx4
      Icon for Memorable Member rankMemorable Member
      3 years ago

      Can you share an example of how is your data before unpivot? Paste here some table with the values you have please. (change names by "AAA" or something like this to keep your data confidential). Because it is weird. Null values doesn't affect in this case

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        mlsx4  please find below the image before unpivot for your reference....