Forum Discussion

RykH's avatar
RykH
New Member
5 years ago
Solved

Multiple Pie or Better Visualization for % Measure Values

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:

 

ZIPRegionState# of Responses above 3 starsTotal # of responses
1ANY710
2ANY811
3BNY45
4BNY36
5CCA88
6CCA710

 

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!

 

 

  • 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.

2 Replies

  • 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's avatar
      RykH
      New Member

      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!