In Y-axis Changing 10%,20% to 0.1%,0.2

[Anonymous]

In Y-axis I have values like10%,20%,30%,40% but now i need to change into like 0.1%,0.2%,0.3%. How can i acheive it?

[v-chenwuz-msft]

Hi @Anonymous ,

You can try this measure to replase the field already existing in the line and chart visual's values. 

Line values Measure = SUM('Table'[line values])/100

If you want to change the y-axis, you can enable the funciton zoom slicer.

But it's dynamic, if you want fix the y-axis,  under Y-axis, enter the range of the y-aixs like the following screenshot.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous if your measure returns 10% 20 % 30% value how come you want to use a different scale for y-axis or divide your measure by 100

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.⚡

[parry2k]

@Anonymous y axis values are auto-created based on the measure you used on the values? Which visual is that?

[Anonymous]

Line and stacked column chart