Forum Discussion
Dynamic Pie Chart
Hi CGran ,
Base on my research, there is no direct method to achieve your requirement. I create a sample pbix file(see attachment) base on your provided data by creating hierarchy slicer with Division and Customer field as a workaround, please check whether that is what you want.
Best Regards
Hi Denis,
Thanks for the affirmation!
I think I know what you're meaning but I'll explain in a little more detail with an example to clarify my problem again.
When I select division 1, the pie chart becomes a solid color, effectively only displaying a whole "pie" which is meaningless information.
What I'd like to do is when the division is slected change from dividing the pie by division, to by customer under that division like this:
To reiterate: I'd like to see my unfiltered data when no slicer is selected, then when a divisional slicer is selected, I'd like the divisional/sales pie chart to become a customer/sales pie chart filtered by the selected slicer.
Let me know if that makes sense!
Thanks,
CGran
Hi CGran ,
Base on my research, there is no direct method to achieve your requirement. I create a sample pbix file(see attachment) base on your provided data by creating hierarchy slicer with Division and Customer field as a workaround, please check whether that is what you want.
Best Regards