Pie Chart Percentage data Labels by category

[tulsi]

Hi,

My pie chart looks something like this.

I have to show the comparison between the two dates and so the percentage lables should equal 100 for a particular date but here i'm getting the grand total as 100. I'm able to do it in a table format by getting the percentage by row but not in a pie chart.

Is there a solution for this?

Thanks

[v-danhe-msft · Accepted solution]

Hi @tulsi,

Based on my test, you could refer to below steps:

Sample data:

Create below measure:

Measure = CALCULATE(SUM(Table1[Value]))/CALCULATE(SUM(Table1[Value]),FILTER(ALL('Table1'),'Table1'[Legend]=MAX('Table1'[Legend])))

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

[tulsi]

Thank you so much! It worked