Multiple Pie or Better Visualization for % Measure Values

[RykH]

Hi All,

Thank you for taking the time to take a look at my question. 

I have created a sample data set that mirrors the problem I am trying to solve. The actual data set isn't based on state or regional data but has a similar breakout which I can't include due to confidentiality.

Please see the below table for context:

ZIP	Region	State	# of Responses above 3 stars	Total # of responses
1	A	NY	7	10
2	A	NY	8	11
3	B	NY	4	5
4	B	NY	3	6
5	C	CA	8	8
6	C	CA	7	10

I have created a measure that calculates: % of Responses > 3 Stars = sum(# of responses above 3 stars)/ sum(total # of responses) which gives me the correct % break down I am looking for. For example for Region A (7+8)/(10+11) = 71% or for Zip Code 1: 7/10 = 70%.

When using a pie chart I put this measure as the values field and the State, Region, and ZIP (in that order) in the legend field of a pie or doughnut chart. It shows me the below:

I would like to see two seperate pie charts and then have the abilitly for them to split into more pie charts as I drill down to the next levels of the report. Is this possible? And if it is, is there a better visualization that I should be using instead? The real data set has 5000+ unique keys at its lowest level so a pie chart obviously wouldn't be the best solution. Any help is much appreciated. I am new to power bi so sorry if this is a poor question!

[MFelix · Accepted solution]

Hi @RykH ,

Have you tried a bar chart with hierarchy? That would give you a better visualization and you could drill down and get the details has you need, since it will appear more bars on your visualization instead of a single bar.

[RykH]

Thank you for the response! We did discuss the bar chart but were hoping we could drill down using pie charts. My work around is that I created a sheet with the guages I wanted to see and enabled drill through. That way we can drill down to which ever level we desire on a bar chart then drill through on a particular area to see how  we are performing in all the relevant metrics. Thank you and if you know of another work around please let me know!