Forum Discussion

Shakti22's avatar
Shakti22
Regular Visitor
8 years ago
Solved

Slicer for multiple columns

I'm working with a senario in which I need to create single slicer for multiple columns, I have tried few DAX quaries with the help of similar questions asked on forum but I was unable to make that w...
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Shakti22

     

    In your scenario, to achieve your requirement. You can refer to following steps:

     

    1. Unpivot your source table columns. To make them as fields in Slicer.

    Go to Edit Queries -> Choose your source table and select column Brand -> Go to Transform option, find Unpivot Columns and choose Unpivot other columns:

     

     

    2. Close & Apply. Then you can simply create Slicers:

     

     

    Thanks,
    Xi Jin.

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
8 years ago

When you load the data, unpivot it before it is loaded. Click the brand column and then select “unpivot other columns”. You can then place a slicer on the new attribute column.