set line chart Y-Axis format independent to the values on the graph

[1600eads]

I'm having issues trying to set my Y-Axis format independent from the values in my line chart. My line chart need to hold values with 2 decimal spots. Is there a way make the Y-Axis values whole numbers instead of 2 decimal points? Instead of 150.00 or 200.00 it should display 150 and 200 respectively. I tried to change the measure format but it seems to control both the labels and values? Any suggestions? 

[Ahidhar · Accepted solution]

Go to the measure in edit sheet > Number Formatting > Number > Formatting > 1000

[1600eads]

It updates both the labels and the values on the line chart. I only want the labels to be whole numbers and keep the values on my line chart 2 decimal points. Any other workarounds? Thank you.

[Ahidhar · Accepted solution]

By default Label Axis  will take the format for the first measure , so if you place 1000 as format for first measure you can add another measure with 'auto ' format and it will show values in decimals

You can create a dummy measure first change it formatting to 1000 and then add  the required measure

Dummy Measure - Sum(0)

you can look into this post 

https://community.qlik.com/t5/Suggest-an-Idea/Set-Axis-labels-number-format-independently-from-the-m...