Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Go to the measure in edit sheet > Number Formatting > Number > Formatting > 1000
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
Go to the measure in edit sheet > Number Formatting > Number > Formatting > 1000
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.
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