Rolling Average Line is Discontinuous when drilling Up the visual

[Anandhu12]

My dataset contains Total sales , So I added a visual that containing a DAX query to calculate Rolling average of total sales for 7 days.

It works fine .I added the rolling average as a  line in line and stacked column chart .The x axis contains date of sales and sum of gross sales on the y axis.When I drill up to see the month or the year level  the rolling average line become discontinous.why does it happen? 

Normal 7 days rolling averagedrill up to see the month level the line become discontinuous at December

drill up to the year ,become discontinuous at 2022 

[amitchandak · Accepted solution]

@Anandhu12 , You can get a continuous axis only with Date or number. That is why at the date level you are getting a continuous axis. For year, too less values for continuous axis