Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 work.
Below is my data view on which I'm working
Brand | top 10 per | top 20 per | top 30 per | top 40 per |
B1 | 0 | 0 | 0 | 1 |
B2 | 1 | 1 | 1 | 1 |
B3 | 0 | 1 | 1 | 1 |
B4 | 0 | 0 | 1 | 1 |
B5 | 0 | 0 | 0 | 1 |
I am looking for solution in which I can select Top 10, Top 20 or Top 40 from filter to reflect only those brands in various charts which denotes 1 in correspond to the selection.
Please help.
Solved! Go to Solution.
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.
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.
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.
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |