Continuous Date axis alignment issue

[bobricenqo]

Hi all,

I am having a problem with alignment of dates on x axis.

While using categorical dates, dates on x axis match the line. But I need to use continous dates, to view future targets in proportion with real values.

 

After changing the dates to continous, the axis shifts. The gridline 2030 mathces the value as of 12.2029. 

If I zoom in, same happens with months. Value as of 06.2025 (EoM) is on gridline corresponding to 7 2025. 

I've used dates table, as recommended, and checked show items with no data. Axis shifts for both all dates and EoM dates.

Is there anyway to correct the alignment of X axis? Or is this, in someway, a desired behavior?

[Ritaf1983]

Hi @bobricenqo 
This is a known issue , please relate to the linked discussion:
https://community.fabric.microsoft.com/t5/Desktop/Incorrect-Anomaly-symbol-compared-to-actual-data-p...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[bobricenqo · Accepted solution]

Thank you for your prompt response. By looking at the linked discussion (and some older posts regarding continuous dates), it seems there is no way to resolve the issue other then using categorical dates? My problem sure is not with timezone shifts.

[Ritaf1983]

Yep , unforunately you're right...the only way to get accurate results by point level is to use a categorical axis.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly