cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
raulallas
Frequent Visitor

Multi layer donut/multiple value donut

Is there a way in powerbi to create a multi layered donut where the 2 layers would have the same groups, but different values. I am trying to use it for showing filtered vs unfiltered values og groups. The final visual would hopefully look somethings like this.

 
 

(https://datavizproject.com/data-type/multi-level-donut-chart/)

1 ACCEPTED SOLUTION

Hey svisswan2 I ended up not finding a single visual to do this, but rather stacking two of the same visual ontop of eachother. i ended up using the donut visual by Drill Down Visuals(formerly Zoomcharts). They have the neat ability to change the scale of the donut so you can stack two of them ontop of eachother and give them the exact same dimensions and just changing the scale of the donut. The bottom donuts title needs to be made white and the top donuts background transparent. The only drawback is interactiveness. Only the top donut will be 'clickable'. 

Hope this helps 🙂

 

Edit: Picture of what i ended up with( labels are whited out which makes it look kinda wierd.)

raulallas_0-1593155224641.png

View solution in original post

4 REPLIES 4
dustinn
Resolver I
Resolver I

I think this visual might help you. You can also import it on Marketplace from Power BI Desktop.

Sadly the sunburst visual doesn't quite have the capability i'm looking for. I need something that would basically display two independent donuts inside eachother.

Anonymous
Not applicable

Hi raulallas - this is exactly the same issue i am having now. i am trying to show two different values nested which are connected by the same group (dimension) but sunburst is not allowing this. Did you ever figure out what visual will allow you to do this nesting two different sets of measures?

Hey svisswan2 I ended up not finding a single visual to do this, but rather stacking two of the same visual ontop of eachother. i ended up using the donut visual by Drill Down Visuals(formerly Zoomcharts). They have the neat ability to change the scale of the donut so you can stack two of them ontop of eachother and give them the exact same dimensions and just changing the scale of the donut. The bottom donuts title needs to be made white and the top donuts background transparent. The only drawback is interactiveness. Only the top donut will be 'clickable'. 

Hope this helps 🙂

 

Edit: Picture of what i ended up with( labels are whited out which makes it look kinda wierd.)

raulallas_0-1593155224641.png

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.