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
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
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
Thank you v-haibl-msft ! :)
I had already thought of that, and I did a workaround by finally making all my graphs either dependant on a separate Calendar or with a new column with the start of the month. All good in the end! Thanks again!