Forum Discussion
TRICKY - Line Graph Plot Issue x axis
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...
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.
3 Replies
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.
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.
