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

Jayfemi's avatar
Jayfemi
Helper I
9 years ago
Spoiler
 

hi v-huizhn-msft 

 

 

thanks for that i really appreicate the time spent on this.

 

i am trying to access the Pbix file that you uploaded but i can't seem to locate it.