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
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....

 

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

    Hi Anonymous 
    And at this point, if you select the four columns and click on unpivot it gives you error for all rows?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      mlsx4  - Sorry for the delayed response. 
      But yeah, am getting error if I select those 4 columns and unpivot it.