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,

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

    Hi v-huizhn-msft 

     

    i believe this will work i am having trouble accessing the file you uploaded when i extract it i cant fine the pbix file.

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