Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |