How to avoid gaps in line chart when having missing dates in the X-axis?

[pedronl]

Hi experts,

I need to build a line chart in Power BI to show the trend of some daily data year over year, but I don't have all the days. How to avoid the gap between the days with data? I need to use the Continuous axis type option (first chart) as if I change to categorical, my data doesn't fit in the chart size I need (second chart).

Thanks!!

[some_bih]

Hi @pedronl it depends, what you want with blanks / zeros.

if you choose "to categorical" then it is preferred to show days with no data.

one alternative is to create Date table, create relationship and apply your measure. Hope this help

[noobraforreal]

Hi, Can you please eloborate with some visuals? I have the same query. Thanks!