Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
Seeking for help. I would like to convert the Count (Distinct) of Employee User ID as column values (staked bar chart on the left) to percentage as staked bar chart on the right.
Thanks in advance.
Solved! Go to Solution.
Hi @alicelpn ,
Unfortunately, there's no options for it now. But you can create a measure like:
Measure = COUNT(Table[Employee User ID])/CALCULTAE(COUNT(Table[Employee User ID]),ALLEXCEPT(Table,Table[Employee code]))
And put it in tooltips, it will show in tooltips when you hover on the stacked bar chart. Please refer to the similar post: https://community.powerbi.com/t5/Desktop/Display-percentage-in-stacked-column-chart/td-p/560354
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @alicelpn !
You will need to create another measure to get [% of Employee Count] in that group;
To get % of Employee Count, you can do it like, [Employee Count] / [Total Employee Per Category]
Then you can place this new measure in normal stacked column chart in [Values] section.
Regards,
Hasham
Thank you Hasham.
I would be very grateful if you can provide me the full DAX as suggested;
[Employee Count] / [Total Employee Per Category]
This is the visualisation pane and I want to maintain the Employee Count at Y-axis and Competence Element at X-axis. The % is to show the no. of Staff for each category of Code within the Competence Element.
Hi @alicelpn ,
Unfortunately, there's no options for it now. But you can create a measure like:
Measure = COUNT(Table[Employee User ID])/CALCULTAE(COUNT(Table[Employee User ID]),ALLEXCEPT(Table,Table[Employee code]))
And put it in tooltips, it will show in tooltips when you hover on the stacked bar chart. Please refer to the similar post: https://community.powerbi.com/t5/Desktop/Display-percentage-in-stacked-column-chart/td-p/560354
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
@alicelpn
You can use the 100% Stacked Column Chart
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi Fowmy,
Thank you for your suggestion. Tried it out and the 100% stacked bar chart shows similar height for all the columns which does not meet the requirement. I want a regular stacked bar chart that displays % of each bar, split between the different columns I have in each bar.
If you put any type of value in Y-Axis, it will always be created based on that. Since you are showing percentages on the y-axis therefore all values will sum up to 100% and your graph will always be a 100% stack chart.
Unfortunately, as of now, you don't have any feature yet to replace Data Labels as another field in default graphs.
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
4 | |
4 | |
2 | |
1 |
User | Count |
---|---|
15 | |
10 | |
6 | |
5 | |
4 |