Forum Discussion
Slicer with Column Heading
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 |
Donut Chart with Total Values
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.
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.
2 Replies
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/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.
