Show aggregated values in piechart legend

Question

Hello everyone,&nbsp;I have been given a task and I am not sure it is possible to achieve in Power BI.I have a piechart, showing count of entities as values and grouped by categories. In the legend of the piechart I want to see not only the name of the categories&nbsp;but also the aggregated sum amount (another field), that belongs to this category, and is affected by filters.&nbsp;I see that it is possible&nbsp;to choose multiple fields as "legend", but I'm afraid it only works as a drilldown&nbsp;setting. Also, it is not possible to aggregate there. &nbsp;&nbsp;Does anyone knows if it's possible to do? Any help would be much appreciated.&nbsp;

anonymous · Answer

This is one of the most basic functions that make pie charts even relatively useful. Not having a legend, showing the value of the slice represented, seems to make the chart useless from a functional rather than purely artistic/visual point of view. This has also ben removed from Excel pie charts as far as I can tell, but they at least allow showing the value inside each actual slice (just not in the legend). Why is this no longer a supported feature? That's like not allowing us to see the specific height of a bar in a bar chart. I can see one slice is smaller/larger than the other, just bot to what actual extent. A question almost always asked by almost anyone looking at a pie chart that actually cares about what it represents!Creating a "fake legend" by showing a grid with the values divorces it from the legend by not allowing it to show the other typical function of the legend, the color of the slice that label represents.&nbsp;I sincerely wish Microsoft valued the usefulness of its chart types, rather than simply ticking off a "requested feature" list as a bare-bones object.

ankitpatira · Answer

AlexeyRusinov&nbsp;Get latest version of power bi desktop -&gt; then drop the field for which you want Sum of under Tooltip section for pie chart.&nbsp;

alexeyrusinov · Answer

ankitpatira&nbsp;, thank you for your answer. That will allow me&nbsp;to add summarized values as a tooltip (appearing info when mouse is over a chart), but what I am trying to do is to add these values in a legend, with color descriptions (showed on a picture below).&nbsp;

ankitpatira · Answer

AlexeyRusinov&nbsp;The only way i think you can do that is create a new calculated column using DAX that will give you sum or count of your value field by category field and then concate that with your category field so creating calculated column as 'Grey Stripe - 100'. Then use that calculated column for your category field in pie chart. Legend shown for pie chart is basically your category field you've used.&nbsp;

alexeyrusinov · Answer

ankitpatira&nbsp;I thought about this, it seems that this option will not work if I want to change filtering (date period, for example).

Forum Discussion

Show aggregated values in piechart legend

8 Replies

Related content

Data Aggregation issue

Percentage in Piechart

Aggregate

Flagpicutres as datalabels in Piechart

PowerBI PieChart Coloring