EOMONTH not align with X axis of chart

[Anonymous]

Hi all,

In reference to Marco's tutorial, I encountered a side effect of using EOMONTH.

Marco tutorial link: https://www.youtube.com/watch?v=Ad_2Z-wXXeU 

In the matrix, the X axis for January 2020 is align with the corresponding values but in the line & column chart, the shared axis is not align, January 2020 is now reflected February 2020.

I also use the line chart and achieved the same negative results.

Regards
Hidayat

[Anonymous · Accepted solution]

Hi all,

If anybody has this issue, you can solve it using StartofMonth in PowerQuery instead.

This enable you to have the continous line chart 

AND

The labels on X axis is align with the Values.

Regards

Hidayat