Forum Discussion

tulsi's avatar
tulsi
Helper I
7 years ago
Solved

Pie Chart Percentage data Labels by category

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

Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    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

2 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    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