How to convert count label into percentage?

[zpaul_010]

Pardon as I'm quite new in Power Bi and im struggling changing my bar chart from total count to percentage. I wanted to show an image of my chart but our company restricts all cloud services so I cant use online services like imgur or photobucket so I'll just try to describe it the best I can. 

So I have a stacked column chart with x axis showing the hour of the day and on Y axis is the count of tickets. The column is divided based on the number of SLAs breached (True or False). I'm trying to show how many SLA breaches are happening per hour. 

On 0 hour for example, from the total of 8, 6 are False and 2 are True. What I'd like to see is instead of 6 and 2, is 75% and 25%. So essentially percentage of each hour.. 

I tried to activate the show value as, but the only option there is % of grand total which is not my objective. 

Any recommendation? 

[Anonymous]

HI @zpaul_010,

Please share some dummy data with the expected result to help us verify your data structure and do test coding formula on them.

How to Get Your Question Answered Quickly 

BTW, you can also try to use the percent version of visuals. (100% cluster column/stacked bar chart)
They can display results with a percent format. (you can use original axis field as axis, category of boolean value as legends, count fields as value)

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@zpaul_010 , refer if this can help

https://community.powerbi.com/t5/Desktop/Showing-percentage-values-in-Stacked-Column-Chart/td-p/1697...