Forum Discussion

Smauro's avatar
Smauro
Solution Sage
8 years ago
Solved

Visuals displaying wrong time on X-axis

Hello all,   So, today (or at least today is the day I noticed) for some reason, my graphs show the wrong date on the X-axis. Whereas the values are, for example, August, it states september on the...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    8 years ago

    Smauro

     

    I’ve got response from the Product Team.

     

    By design. The Scalar axis is continuous/linear, and is automatically choosing best intervals. Monthly intervals are chosen, and default to 1st of the month. Imagine a scalar numeric axis - 10, 20, 30 are fine, you wouldn't expect 19, 29, 39 to be your value axis labels right? The Aug 31th column is plotted a few pixels left of the Sep 1st axis label in the repro screenshot.

     

    Best Regards,
    Herbert

vallemedef's avatar
vallemedef
Regular Visitor
2 years ago

Hi, 

I met this behaviour today and, luckly, was able to solve it, at least for my case.

 

I use following calculated column and use it for x-axis:
MMM YY = EOMONTH('Calendar'[Date],0)
And as result I got following chart:

 

As you can see there are wrong labels on it.

 

 

Changing the dates from End of Month to Begin of Month helped me here:
MMM YY = EOMONTH('Calendar'[Date],-1)+1