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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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. 

@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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.