Pie Chart to Show Data Properly

[valleyman]

I have the following data:

I have then imported this into PBI but it's not allowing me to show the data how I would like. Ideally, I would like the top level of the donut to show the total number of Low, Medium and High across all communities within the location, and drill-downs to show the L, M and H for the four separate communities. Is this possible?

Of course, I could create four donut visualisations to show each community in more detail, but I am trying to use the report as a template for other locations, changing just one or two parameters to avoid over-duplication, and other locations do not have the same number of communities within them.

Any tips or ideas would be appreciated...

Thanks

[AlexAlberga727 · Accepted solution]

@valleyman 

At first I was thinking of a sunburst visualization. Check these out and play with them a bit to see if you can get your expected result. They're an interesting visual.

However - I rearranged your table a bit and got to this point let me know if this is what you're looking for.

[Tahreem24]

You can download the custom visuals like Sunburst, Donut chart by ZoomChart pro Edition etc.

[amitchandak]

@valleyman , The information you have provided is not making the problem clear to me. Can you please explain with an example.

I think you might have to unpivot the column and do it

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

Appreciate your Kudos.

[valleyman]

OK, let me explain a little better. 

The chart above shows the Low, Medium and High values for each of the 'communities' within a 'location'. I have several other locations that I wish to use the same, basic pbix template for, save for altering some parameters in each. 

I would like the donut to show me, at the top level, the total number of Low, Medium and High for ALL communities combined. For the example above, that would be Low = 35, Medium = 43, and High = 6. Upon drilling down one level, for it to show me the total Low, Medium and High for each of the four communities present. So C1 = 11, 9 and 0. C2 = 9, 7 and 0. C3 = 7, 23 and 5. C4 = 8, 4 and 1.

Is THIS possible?