Stacked column with total number but percentage data label

[Anonymous]

Hello experts,

I am having hard time for last few hours on this.

i have a stacked column line chart where I created columns with total value. X axis has months and Y has total value with 5 categories in each column as each stack. Now I was asked to keep the same graph but data label would be percentage based on each column instead of total value.

so for November, if I have 5 categories as stack, the stacks should be labeled as 24%, 28%, 24 %, 12%,12% instead of real values in millions that I used to make the graph.
I tried to make measure or calculated columns for % and use them as lines . But lines do not align with categories in stack. 

Any idea how to do? 
Help will be appreciated

thanks

[Anonymous]

Did you try 100 % Stack column chart, you can see the values in percentage-

Appreciate your kudos!! Mark my post as solution if this helps.

[Anonymous]

They do not want that. With total value we are seeing a trend so they would like to keep that but data label as % 

[amitchandak]

@Anonymous , refer if this can help

https://www.youtube.com/watch?v=qeWN5gq9EE8

[Anonymous]

Thanks,

does not help though. First I do not need %of GT but column wise percentage and that's why I created measures and used as line axis, 

and is having problem as data labels for lines do not match the stacks in column chart.

[Anonymous]

Hi @Anonymous,

Can you please share some dummy data and expected results to help us clarify your scenario and test coding formula on it?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anonymous]

@Anonymous Take a look at the posts- https://community.powerbi.com/t5/Desktop/Percentage-Data-Labels-for-Line-and-Stacked-Column-Chart/td-p/224060 

https://community.powerbi.com/t5/Desktop/Display-number-and-percentage-at-same-time-in-bar-chart/td-p/395982

Appreciate your kudos!! Mark this post as solution if this helps.