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 ...
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

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

  • tulsi's avatar
    tulsi
    Helper I
    7 years ago

    Thank you so much! It worked