This will drill you down to show the breakdown of TYPE for each supplier and show you the percentage you’re after. To do this, click on the down pointing arrow to turn drill down on and then click on a supplier’s segment in the pie chart. If you put the TYPE column also in the Legend bucket under SUPPLIER, you can then drill down to the percentages for each SUPPLIER. This is where the drill down can help us. But what we’re itching to do here is to show what percentage each wine type is of each supplier’s sales, not of the total sales. Of course, this is how the pie chart has to behave because a pie chart must always show the ratio of the parts to the whole. Because of this, I’ve had to display the legend so we can tell which colour is which supplier. Notice how the detail labels show percentages for the “Details” rather than SUPPLIER. In the example below, we’ve added the wine TYPE (Red or White) column into the “Details” bucket:. #5 Make the Chart “Details” Work by Using Drill Downįirstly, what do we mean my “chart details”? This is where you get a whole load more percentages to peruse because the “details” give you a further breakdown of the category that you’ve put in the legend. Remember, that slicers filter data whereas chart highlighting does just that it highlights the selected data but any calculations are still performed on all the data. In the second pie chart, the percentage of 33.37% is the percentage that Laithwaite’s sales comprise of the total sales in 2019 only. Why the different percentages? In the first pie chart, the percentage of 10.71% is the percentage that Laithwaite’s 2019 sales comprise of total sales for all You’ll notice now that sales for supplier Laithwaites now has a percentage of 33.37%. However, in the pie chart blow, we’re using a slicer to filter sales for 2019. You’ll notice the sales for supplier Laithwaites has a percentage of 10.71%. In the first one, we’re using a table visual to highlight 2019 sales. #4 Beware of What Percentage You’re Looking AtĬonsider the two pie charts below. Why don’t you turn off the legend and replace it with “Category, percent of total” as the label style, as shown below:. Is there any point in showing the legend? It just takes up space and to use it, you have to consistently match the colour to the segments.
#3 Get Rid of the Legend and Replace it with Category Labels You sort the pie chart just like any other visual by using the “More options” button and selecting the correct value by which to sort. …which can sometimes look rather odd as in the above example where you would want the years in the correct order. The default sort order of the pie chart is the same as other visuals, that is descending by value…… However, Power BI has given you the pie chart to use so at least use it with restraint. Personally, I think pie charts are only useful if you’re showing the ratio of two categories, because it’s the only situation where the pie chart is easy to decode:.