Round bar chart values, differently than hover values

[Anonymous]

I would like to know how to round decimal values in a bar chart, so that it shows rounded on the graph but when I hover over it, it shows the unrounded value. Because I did this bar chart using a measure and tried to use the function round but it does not responds to my needs.

[jcrojas1]

Hi!

This solution is correct, but I want to round up the values like this:

88.6% = 89%

5.6 = 6

5.04 = 6

As long as there is a single decimal, it will always round up and no down.

An example of an incorrect round will be:

5.04 = 5

Your solution does the second case. Is there another way?

[v-alq-msft]

Hi, @Anonymous 

I'd like to suggest you format the decimal values in the 'Column tools' and modify the number of deciamal places shown for this value as 0.

Best Regards

Allan

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

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Click on your bar-chart. Under format options, set decimal places = 0

Thanks,

Pragati