Dynamic Donut Charts

[rohittunga]

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 charts in this case, each chart showing Total Cost for Projects, Ideas and Gap.

However, when the User clicks Automotive, I need donut chart for each Department under Automotive like Final Assembly, Press Shop for the same measures (Total Cost for Projects, Ideas and Gap). Same holds true for other Divisions (Aviation and Transportation).

I am able to create charts at Division Level, but not able to display department specific charts inthe same dashboard. Any pointers on how to proceed ?

Thanks!

[BhaveshPatel]

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]

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]

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

[BhaveshPatel]

Step 1Step 2Step 3Step 4