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.

v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
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.