cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rax99 Member
Member

Dynamically Change Legend of a PIE Chart based on Table Selection

So the idea is if I click on a different level of a hierarchy on the table/matrix visual, the Pie chart's legend/categories update to that new level

 

So what's required is;

- On the left nothing is selected in table so should show legend of highest level (so client ID s)

- On the right a client (ClientID = 3) has been selected so the pie should split by the Departments for that ClientID

 

unfilterered pie.JPGunfilteredfilterered pie.JPGfiltered

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I couldnt really figure out how to change the legend selection on the pie chart to reflect based on the selected level of the hierarchy. Any advice will be brilliant.

1 REPLY 1
Community Support Team
Community Support Team

Re: Dynamically Change Legend of a PIE Chart based on Table Selection

HI, @rax99 

After my research, I'm afraid it couldn't achieve in Power BI for now.

But you may try these two custom visuals.

10.JPG

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.