Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Round bar chart values, differently than hover values

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.

  • Hi Anonymous ,

     

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

     

    Thanks,

    Pragati

3 Replies

  • Hi Anonymous ,

     

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

     

    Thanks,

    Pragati

  • v-alq-msft's avatar
    v-alq-msft
    Community Support

    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.

  • jcrojas1's avatar
    jcrojas1
    Frequent Visitor

    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?