Forum Discussion

simonxiao's avatar
simonxiao
Regular Visitor
9 years ago
Solved

Chart did not display decimal correctly

The actual data in database (Azure SQL Server) is 497.60; but when displaying on the chart, it shows as "497.5999999997".

This looks like happened ramdonly. The same set of data (data from the sam SQL data table column) will display correctly in other points.

 

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi simonxiao,

    Please choose your field first on Fields Pane, and then in the modeling tab, you can choose how many decimal places you wanna show like the following screenshot(highlighted in red line).




    If you have any issue, please let me know.

    Best Regards,
    Angelia

     

4 Replies

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi simonxiao,

      Please choose your field first on Fields Pane, and then in the modeling tab, you can choose how many decimal places you wanna show like the following screenshot(highlighted in red line).




      If you have any issue, please let me know.

      Best Regards,
      Angelia

       

      • simonxiao's avatar
        simonxiao
        Regular Visitor
        9 years ago

        Is this a bug? The data saved in database is correct stored; and the data show on the label is correct; why the data showing on the chart sometimes is not correct?