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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
danie_figueroa
Frequent Visitor

Continuous lines in graph with data cut between months.

I need my area chart to show no gaps when filtering the data with year and month filters. That is, if there is no sales data between May and August 2021, the line is currently cut off in the months that no sales are recorded. so between May and August the line disappears. I need it to always show up.

 

danie_figueroa_0-1681936798514.png

 

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

Share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

To report on things that are not there you need to use disconnected tables and/or crossjoins.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!