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
Jo5hua22
Helper I
Helper I

Showing Year in X Axis even if it has null values

Hello Members,

 

I would require your help in solving a visualization query

 

The query is I would like to view null values in X axis. For certain visuals, I am able to visualize null values but for other visuals, I am not able to see them. Can you please let me know how to resolve this?

 

Example: Expectation that I want is

 

Jo5hua22_1-1630475121731.png

 

 

 

What I am seeing:

Jo5hua22_0-1630475061667.png

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@Jo5hua22 

Select the chart then right-click on the Axis field and select Show Item with no data option

 

Fowmy_0-1630478221177.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

3 REPLIES 3
V-lianl-msft
Community Support
Community Support

Make sure it is a date hierarchy so that dates will be continuous.If there is no continuous date in your data model, please create a calendar table and create a relationship with the fact table.

Calendar = CALENDAR(MIN('TABLE'[DATE]),MAX('TABLE'[DATE]))

Vlianlmsft_0-1630657857335.png

 

Fowmy
Super User
Super User

@Jo5hua22 

Select the chart then right-click on the Axis field and select Show Item with no data option

 

Fowmy_0-1630478221177.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

In my scenario I have age buckets and when I apply a filter to my BSA groups for example i only get to see the buckets that have values. I would like to see all buckets still even if value is null or just empty. Is there a shortcut for that as well? The solution above is turned on but does not quite do the trick. My buckets are on the X-axis. 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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