Forum Discussion
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.
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
6 Replies
PaulDBrownCommunity 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.
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
- amitchandak
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
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
- VahidDM
- jeroenterheerdt
Microsoft Employee
yeah, I saw this but not going to reply here 🙂
