Bar chart with changes between absolute number and %ages

[Harsh]

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 you find this useful.

Thanks & 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…