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

Smauro's avatar
Smauro
Solution Sage
8 years ago

Hi again v-haibl-msft

 

I managed to strip down some data and the problem reappeared. The reproduction was easy: 1)have a datetime column, 2)add new transforming it to day, 3)add new transforming it to endofmonth. (All via queries) 



Is filebin ok? https://filebin.ca/3gSJCrYni915/testpowerbi.pbix

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
8 years ago

Smauro

 

Thanks for your PBIX file. I’ve reported it internally to Power BI Team: CRI 51216807
I’ll post here once I get any update about it.

 

Best Regards,
Herbert