Create a Pie Chart from Matrix Table

[avi081265]

Hello,

I want to create Pie chart for each plan and their status. Pie chart fiels are 

and data are populated as in matrix visual table as mentioned below. I want to create pie chart for each plant. How can I do this

[PhilipTreacy]

Hi @avi081265 

For data as you present, a Treemap is ideal

Regards

Phil

[avi081265]

Hello Phil

Thanks for reply. Table I mentioned it is sample, I have 100's of location and thei related status. Managing 100+ locations in treemap will not look good.

[PhilipTreacy]

Hi @avi081265 

But you want 100's of Pie Charts?

Maybe I'm misunderstanding what you are looking for as a solution?

regards

Phil

[avi081265]

Overall, I have to display 80 pie charts in a dashboard. We will display 20 small pie chart in each tab depending on some grouping.  Let me know if we have some better suggestion.

[AlexisOlson]

I don't think the small multiples visual in Power BI allows for pie charts yet.

However, I've used this xViz Advanced Trellis visual before for similar purposes:

https://xviz.com/blogs/key-enhancements-to-advanced-trellis-small-multiples-power-bi-custom-visual/

[avi081265]

Hello AlexisOlson,

The above table, it is just sample. NUmbers are higher and plants are more than 20.  

The url you shared, it is third part component. I am looking for solution inbuild PowerBI. I already tried filter based up on Plant column. So depending on plant selection, pit chart change dynamically. But I want to create pie chart for each plant seprately.

Thanks for your suggestion.