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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

How to display all X axis values even if y values corresponding is null

Hello dear member !

 

Please I would like to know how I can show all X axis values even if corresponding Y value is null.

Even if I click on "Show items with no data"  all X values don't display.

faypy_0-1698305001359.png

 

Thanks in advance

7 REPLIES 7
Syndicate_Admin
Administrator
Administrator

Hello. In my case it's different, I don't want to show values on the X axis for those that don't have value on the Y axis.

HOMERO_0-1713910939762.png

Anonymous
Not applicable

There is no filter applied FYI

Anonymous
Not applicable

Thanks for reactivity @Uzi2019 

Below it is :

faypy_0-1698309308370.png

In fact, for the X axis line, I should have 19 status but only 16 are displayed as for 3 others there is not Y value corresponding. 

 

FYI, I am not using a measure

Anonymous
Not applicable

Hi @Anonymous ,

 

In addition to checking if the filter has removed the values of the three x-axes, you can also check if the fields of your x-axis themselves contain values that do not appear.

If you can, please provide some more information along with screenshots. Remember to protect your privacy.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

hi @Anonymous 

I can see the data even if the value against it as 0.

Uzi2019_0-1698314576616.png


Please check the filters you might applied on visual. 

 

If my post helps please give kudos and accept it as  a solution!
Thanks

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Uzi2019
Super User
Super User

Hi @Anonymous 

Can you share the screenshot of chart? world be easier to understand what you want to see on chart.


Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Anonymous
Not applicable

Hello @Uzi2019 @Anonymous 

Below you can see  another chart in the same type. The problem is the same. Normally 19 status should be present on X-axis bar. The status that are not showing have no Y value in data sources.

faypy_0-1700754082037.png

 

Helpful resources

Announcements
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 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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