Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
pedronl
New Member

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).

pedronl_0-1686952760578.png

 

Thanks!!

2 REPLIES 2
some_bih
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.