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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Exploded pie chart (pie of a pie)

I am looking for a visual that will give me a pie of a pie, or something similar.

 

This is to show how different funds make up the total amount of the portfolio. Then within each fund show the number of projects that make up each fund. So for example just because #1 fund may be the highest in $ value, is also has the least amount of projects in it, where as fund #2 may be less in $ vaule but has more projects.

 

I want to use this visual to start creating insights on our funds and high value projects vrs lower value projects etc. At the moment I am creating 2 x separte pie charts and just placing them side by side, one by sum amount and one by count. Would love a tidier way to show this. 

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

Create the pie chart using both the fund and project field. Then use the Drill-Through option on the chart: select the icon in the header with an arrow within a circle. When you then click on a fund section of the pie, the pie will then show the detail by project.

drill.pngdrill.gif

Or, use a report page Tootip if you want to keep the fund pie chart in view

rpt.gif

 For report page Tootlips, see:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop 

 

Sample PBIX file attached





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

6 REPLIES 6
PaulDBrown
Community Champion
Community Champion

Create the pie chart using both the fund and project field. Then use the Drill-Through option on the chart: select the icon in the header with an arrow within a circle. When you then click on a fund section of the pie, the pie will then show the detail by project.

drill.pngdrill.gif

Or, use a report page Tootip if you want to keep the fund pie chart in view

rpt.gif

 For report page Tootlips, see:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop 

 

Sample PBIX file attached





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Anonymous
Not applicable

Thanks, this looks like as close as I'm gonna get to the visual I need, thank you!! I will keep an eye out for new custom visuals that may get me closer to what I'm looking for, but this is choice. 

VahidDM
Super User
Super User

@jeroenterheerdt 
FYI

 

:))

yeah, I saw this but not going to reply here 🙂

amitchandak
Super User
Super User

@Anonymous , For that you need a double donut chart, check if this visual can help

 

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380858?tab=Overview

Anonymous
Not applicable

Have tried the Advance pie and Donut visual from xViz and also a sunburst, and they aren't quite right. Rather than a layered donut/pie chart I need a expanded/exploded out one like Excel offers. 

Like the one shown in the below link

 

https://www.officetooltips.com/excel_2016/tips/creating_pie_of_pie_and_bar_of_pie_charts.html 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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