Change Value that Horizontal Axis Crosses

[OwenGaylard]

Hi,

I have a bar chart showing overall productivity against an expected level (100%) where exceeding the expected level gives a score above 100%. Values range from about 80-110% and it currently looks like this -

As 100% is our reference point I would like the horizontal axis to cross at 100% instead of 0% so that it looks like this (example on Excel) -

Does anyone know how to change the value that the horizontal axis crosses? I'm aware that I could minus 100% from the data values so that they do display as desired but for consistency with other reports would prefer not to alter the data values.

Thanks

Owen

[Anonymous]

HI @OwenGaylard,

As parry2k said, current you can't directly achieve these in common visuals.
For this scenario, you can try to create measure formulas and use them on visual or try to use script-based visuals(r, python) to manually plot your visual graphs.

Regards,

Xiaoxin Sheng

[parry2k]

@OwenGaylard I think you already know the solution, nothing out of the box, You can create another measure for this specific use case and that way you are not changing the actual measure.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡