use column name as slicer and it should linked with donuts chart

[Anonymous]

Hi All, I want to create a slicer where column name will inserted as slicer and when I click on slicer it should change the data in donuts. I don't want to use multiple charts and want to sow only one chart but it should change when i click on slicer(columns Name)

Please see the screenshot below where is have shown my whole data. I am not sure where to upload PBIx file and attaching screeshot here.. Here is the table:

BadgeID	Job Title	Country	FirstName	LastName	BoothNumber	Booth Name	Duration Seconds
123	Engineer	USA	abc	Woods	27	Booth 1	600
456	Engineer	Germany	def	Woods	27	Booth 1	480
789	Engineer	India	ghi	Sa	27	Booth 1	1320
532	Chief Information Officer	USA	jkl	Va	14	Booth 2	240
1182304	Operations Manager	USA	Chet	Manchester	21	Booth 3	980
1182523	Account Manager	USA	Travis	Fulton	21	Booth 3	1080
1182657	Senior Engineer	India	Luisa	Sangines	21	Booth 3	1680
1182879	Engineer	USA	Mark	Skallet	21	Booth 3	480
1149995	Analyst	USA	Megan	Hemmila	37	Booth 4	1200
1149995	Analyst	India	Megan	Hemmila	37	Booth 4	2280
1150180	Architect|Partner	India	Hoa	Tram	37	Booth 4	1200
1150180	Architect|Partner	Germany	Hoa	Tram	37	Booth 4	480
117	Senior Engineer	USA	pqr	Pa	14	Booth 2	360

Here is the screenshot for my problem:

[Anonymous · Accepted solution]

Hi @Anonymous,

I'm pretty sure this could be done with DAX but my skills aren't sufficient.

However there is a workaround, but it still includes 2 charts:

• You could create two bookmarks and link the buttons (Job title / Country) to these bookmarks
• These bookmarks would be the same but one would show just the job title donut and the other one would show the country donut
• This would create the effect that there was only one donut.

Here's a reference

Hope this helps.

Br,

T

[Anonymous]

@Anonymous This trick worked like a charm! Thank you very much. I will really appriciate if PowerBI make it more simple.

[Anonymous]

@Anonymous

Glad I could help! Be sure to mark my answer as a solution if it solved your problem.

Br,

T

[Anonymous]

@AnonymousDone!