Charts shows many times the same number

[SwenWa]

Hi Team,

I have a chart with 1 measure. This measuere is set to: num( formula ,'#.###.###')
The number formatting is "number" and formatting simple is "1.000".

Problem: It shows often the same number on the x-axis:

When I change the formatting simple to "1.000,0" I can see that is:

0,0 // 0,5 // 1,0 // 1,5 ...

Any idea how to fix this? Thanks 🙂

[jwjackso · Accepted solution]

The repetitive numbers are fractional differences.  That is why you have 1,0 and 1,5 when you format to show the decimal.  Use the Round()  function to display whole numbers.