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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.