TRICKY - Line Graph Plot Issue x axis

[Anonymous]

Hi Experts

Trying to plot the following MA7 day graphs as shown in the image - my issues is the x Axis i cannot get it as shown in the image... The image is from an excel graph..

Sample data

https://www.dropbox.com/s/5gou2apwfo76ast/Test__.123pbix.pbix?dl=0 

Expected end result...

[lbendlin · Accepted solution]

Yes, this was indeed surprisingly tricky.  You have to consider Feb 29 and incorporate the leap year rules , otherwise the sorting won't work.

see attached.

[v-jianboli-msft]

Hi @Anonymous ,

If you want a similar X-axis, you can replace the X-axis field in visual with this:

Final output:

Best Regards,

Jianbo Li

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

[Anonymous]

Hi Community support your graph looks nothing like the finished product?