Slicer with Column Heading

[Riteshheda]

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.

[Anonymous · Accepted 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.

[amitchandak]

@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/