Trying to get it shown as actual percentage

[Harsh]

Hello @Stefan,

Thank You for posting your query onto the Forum.

Have you tried using the simple % format. Because if you try using the Format function the numbers will get converted into the text. And will simply either show the figures in the decimal figures or will show blank as is your case.

By the way are you trying to analyze the charts using slicer where you select Numbers and the Percentages option and accordingly the charts changes.

I’m also providing a link below where similar type of query was asked onto the forum by one of our member and how the solution was achieved.

Hoping you find this useful and meets your requirements.

If you need anything just give a shout.

Please Note: Click on the link to view the entire post and not on the expand/collapse button.

Thanks and Warm Regards,
Harsh

Switch axis between numeric and %

Hello @satichun, Still it wouldn’t be possible because when you use the "SWITCH( TRUE () )" logic the percentage number will still show it as 0.00 Format on Y-axis instead of 0.00% although you may have 2 different measures. I would like to take an example to explain it to you on the basis of screenshot provided below - [Switch Format on Y-Axis Based on Slicer Selected - 1] [Switch Format on Y-Axis Based on Slicer Selected] In the given example, I’ve two different measures one is “Total S…

Providing one more link.

Bar chart with changes between absolute number and %ages

Hello @Stuart, Thank You for posting the query onto the forum. Few days back one of our members also had the posted same type of query onto the forum. Unfortunately, as of now there’s no solution in Power BI to switch your axis or chart labels in “0.00” format and the “0.00%” format at the same time. And this is because when we apply “0.00%” format it converts the numbers into a text. I’m also providing a link of a query which was posted and the solution I’d provided to our member. Hoping y…