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
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

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