Forum Discussion
Visuals displaying wrong time on X-axis
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
Hey v-haibl-msft . I just checked and I have exactly the same version. The problem still persists however. I should mention that the Date axis is monthly (one date per month) and not daily. Could this be the reason why PowerBI gets confused?
I did it like that because I found graphing last x month with hierachy was almost impossible.. Always showing like that
(yes, I have no idea why 2017 December is even displayed in that one).
So, back to the first issue. Do you think it may be a fault of the Month grouping? Should I try with a separate calendar?
EDIT: Oh, I should mention as well that my filters are not slicers, they are page lever report filters. I don't know if this should make a difference, it shouldn't..
EDIT2: So, I've found the reason. I had transformed the MonthOpen column to DateEndOfMonth so I could compute some monthly backlogs, and even if the value is, for example, 31/Oct/2017 the graph will put it close to the "continuous" November, hence all graphs end up showing this way.
Another work-around is to set the X-Axis type to Categorical instead of Continuous