Forum Discussion

Jayfemi's avatar
Jayfemi
Helper I
9 years ago
Solved

Percentage Data Labels for Line and Stacked Column Chart

Hi i have got a Line and Stacked Column Chart and when i select data labels i am given the sum for each segment in the chart. Ideally instead of the sum i would like the percentage of that segment to...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Jayfemi,

    If my understanding is right, you can create several measures using the formulas.

    NewCompleted = SUM(Data[Completed])/SUM(Data[Allocated])
NewFollow = SUM(Data[FollowOn])/SUM(Data[Allocated])
NewNoAccess = SUM(Data[NoAccess])/SUM(Data[Allocated])
NewNoAction = SUM(Data[NoAction])/SUM(Data[Allocated])


    Add the measures as value levels, you will get the following result, please review and download the pbix file.



    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi Jayfemi,

Please create a measure using the formula below, and add the measure as value level.

Percentage=sum(Table[value])/CALCULATE(SUM(Table[value]),ALL(Table))


If this still does not resolve your issue, please share your sample table and list expected result.

Best Regards,
Angelia

Jayfemi's avatar
Jayfemi
Helper I
9 years ago

Hi Angela,

 

I hope this finds you well, thank you very much for your time i really appreciate it. The fomula does solve one of my problems it is now but getting it to show up on the visual.

 

i used the formula as like this treating the Allocated as the total so on the visual instead of seeing the sum of completed jobs i'd like to see that as a percentage of the allocated jobs.

 

CJP Percentage = sum(Data[Completed])/CALCULATE(SUM(Data[Allocated]),ALl(Data))