Values in the legend in pie chart

[Anonymous]

Hi Experts,

Is there a way where I can display values in the pie chart legend?

Appreciate your help.

[mschelah]

Hi, how did you show those percentages next to your legend?

[amitchandak]

@Anonymous , I doubt that option as of now. You have to show it on the label.

You might have create a table and show it using % of total

[Anonymous]

Thank you @amitchandak . Appreciate your response.

On that percentage calculation, could you please help how to write total sum for denominator?
For example Sum(Measure field)/SUM(Total Measure field) to give the percentage.

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

Please try the ALL function,

total sum for denominator=CALCULATE([sum for division],ALL('Table'))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mschelah]

Can you provide a little more information on how to do this? You say to use the All function. However, as of now, I only have my pie chart showing my legend. I want to show the values of each commodity next to it. Can you help? Do I create a table and then hide it? I don't need a table to show.