Percentage Data Labels for Line and Stacked Column Chart

[Jayfemi]

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 only be visible over the Sum.

is this possible or can this be added as a tooltip instead?

[v-huizhn-msft]

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

[degnek]

This solution for me is parsing the percentage across the entire chart instead of breaking based on x-axis categories. Is this the intention and/or is it possible to get it to break down by the x-axis categories? For instance in my chart I break it down by group, and am needing to look at what percentage each group has for stories that are completed vs not. 

Example of data:
Table <Monthly Totals>

<Month><Area><Category><NumValue>
Jan JK  Stories Completed 8

Jan JK  Not on Time 2

Jan JR  Stories Completed 6

Jan JR  Not on Time 1

Feb JK  Stories Completed 30

Feb JK  Not on Time 1

Feb  JR  Stories Completed 15

Feb JR  Not on Time 1

[Jayfemi]

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

[Jayfemi]

Hi Angela,

please see link cotaining my PBIX file and excel sheet that i am working from

https://www.dropbox.com/s/waxp8oqx0d805r9/Percentage%20Data%20Labels%20for%20Line%20and%20Stacked%20...

[v-huizhn-msft · Accepted solution]

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]

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.

[v-huizhn-msft]

Hi @Jayfemi,

I upload it to OneDrive, the following is the shared link, please click and download it.

https://1drv.ms/u/s!Av62M_jYbMcegQsSD2CnW3jwdBZb

Best Regards,
Aneglia

[Jayfemi]

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.