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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
rjmajid
Frequent Visitor

Line chart show items with no or zero data

I am facing an issue of showing data of all months even if there is no or zero data. I know the option of 'show items with no data' but that show all data without considering the filter context. I need to show all data for selected time period only. Do you guys have any idea?

rjmajid_0-1686730430190.png

 

3 REPLIES 3
Adescrit
Impactful Individual
Impactful Individual

Hi @rjmajid 

 

First thing I would try is ensure your X-axis is set to "Continuous" and not "Categorical".

Adescrit_0-1686732642457.png

 


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

Yes, its continoues
Adescrit
Impactful Individual
Impactful Individual

Hi @rjmajid 

 

There are a couple of other things you could try:

  1. Reduce the font size of the x-axis data labels.
  2. Use a different field in the x-axis. Instead of the full month name, use a shortened version, i.e. "Mar" instead of "March"
  3. Increase the size of the visual.

 


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

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors