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

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

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