Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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/)
Solved! Go to 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.)
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.
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.
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 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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
84 | |
66 | |
49 |
User | Count |
---|---|
140 | |
114 | |
108 | |
64 | |
60 |