Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
They do not want that. With total value we are seeing a trend so they would like to keep that but data label as %
@Anonymous , refer if this can help
https://www.youtube.com/watch?v=qeWN5gq9EE8
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.
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 Take a look at the posts- https://community.powerbi.com/t5/Desktop/Percentage-Data-Labels-for-Line-and-Stacked-Column-Chart/td-p/224060
Appreciate your kudos!! Mark this post as solution if this helps.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |