Forum Discussion

CGran's avatar
CGran
New Member
5 years ago
Solved

Dynamic Pie Chart

Hi All,   I'm new to the forum so if I'm posting in the wrong place please forgive me.   I'm attempting to use slicers to modify a pie chart dynamically.   Basically I want to have a pie chart ...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey CGran ,

 

the section seems to fit 😉

Drag the column with all divisions to the slicer and to the pie chart. In the pie chart add a column with values like amount or sales amount or something similar. Then you should  get the result you want.

 

In general when you describe a problem screenshots often help to see the error faster.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis