Exploded pie chart (pie of a pie)

[Anonymous]

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. 

[PaulDBrown · Accepted solution]

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.

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

 For report page Tootlips, see:

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

Sample PBIX file attached

[Anonymous]

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]

@jeroenterheerdt 
FYI

:))

[jeroenterheerdt]

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

[amitchandak]

@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]

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