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.
Dear All,
Trying to create a slicer with column headings for Donut Chart.
Variable | 1-50 | 51-100 | Total |
A | 1 | 5 | 6 |
B | 2 | 6 | 8 |
C | 3 | 7 | 10 |
D | 4 | 8 | 12 |
E | 5 | 5 | 10 |
Want Slicer to look like below
Slicer
[tick option] 1-50
[tick option] 51-100
[tick option] Total
So that the donut chart gets updated accordingly.
Please help and suggest.
Thank you.
Solved! Go to Solution.
Hi @Riteshheda ,
Please select Variable column and Unpivot other columns as shown below:
Then you could achieve the result you expect.
Here is the pbix file.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Riteshheda ,
Please select Variable column and Unpivot other columns as shown below:
Then you could achieve the result you expect.
Here is the pbix file.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Riteshheda , see like you looking for very similar stuff
Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |