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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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