Forum Discussion

rohittunga's avatar
rohittunga
Frequent Visitor
10 years ago

Dynamic Donut Charts

I have a slicer which contains Divisions like (Select All) Automotive Aviation Transportation When the User Clicks Select All, I need a donut chart for each division. Therefore I need 3 Donut ...
Need Help
Show and Tell
BhaveshPatel's avatar
BhaveshPatel
Super User
10 years ago

You can use drill down feature of the PowerBI to create your chart and use atttribute slicer visual ( can be downloaded from POWERBI Visuals Site) to set your slicers at Hierarchy level.

 

or 

 

You create hierarchy in your model and use hierarchy to create donut chart.

 

Hope this would solve your problem. 

 

if you can provide a snapshot of dataset, I am happy to provide you exact solution.

rohittunga's avatar
rohittunga
Frequent Visitor
10 years ago

Here is the screenshot of the dataset.

 

The first report should look like this (that is when user chooses "Select All", each division appears as a separate donut chart.

 

 

If the User chooses a particular Division, say Automotive, then departments under Automotive should appear as Donut Charts like the one below.

 

 

Likewise if user chooses Aviation then 2 donut - One for A380 and other for B777. And if User chooses Transportation, then 3 donut chart - One each for Railroad, Ship and Air. I'm able to recreate these in separate pages, but unable to create them as a single visual that dynamically changes based on Slicer input

 

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    10 years ago

     

    Step 1Step 2Step 3Step 4

     

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    10 years ago

    Create a Hierarchy based on Division, Department, Productline and Transport ChannelUse same hierarchy for the hierarchy slicer as well