Year over Year Comparison With Leap Year

[mikegee78]

Hello - Is there a way to connect the lines on a line graph for years where it isn't a leap year?  Essentally, can I connect Feb 28 to Mar 1 for 2019 and 2021?

[amitchandak]

@mikegee78 , Try continuous Axis. But you might not get the final objective

[mikegee78]

@amitchandak I don't seem to have that option....  

[v-jingzhang]

Hi @mikegee78 

If you want to connect the lines for years where it isn't a leap year, you will need to have data for February 29th in these years. However if you give some fake data to these dates in non-leap years, is it ok for your model?

I would suggest to add a Year slicer in your report. When you want to see the data at day level, select a single year in the slicer to see the detailed data. When you want to see the data at month or quarter level, select multiple years so that you can compare the data trend in these years. Or you can consider using two charts to show the month trend and day trend separately.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.