Forum Discussion
How to avoid gaps in line chart when having missing dates in the X-axis?
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...
some_bih
Community Champion
Community ChampionHi 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
Hi, Can you please eloborate with some visuals? I have the same query. Thanks!