Forum Discussion

pedronl's avatar
pedronl
New Member
3 years ago

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 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!!

2 Replies

  • some_bih's avatar
    some_bih
    Community Champion

    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's avatar
      noobraforreal
      New Member

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