Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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

6 REPLIES 6
Numerro
Advocate I
Advocate I

I'm not sure these will match what you're looking for, but I do know donut charts can be frustrating to design and format. For anyone interested, we built some basic tips for building donut charts and have example Power BI donut charts for inspiration.

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

@raulallas the idea you gave is really good. I tried setting the inner one with no background and the outer one with background. Place the inner one inside the donut chart with zero padding. This will allow both the visuals to interact individually.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.