cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Show column even if value is blank

I'm using a categorical x-axis for a simple column chart. In this case, it's important for me to always show all categories - to show those categories with blank (or 0 value). The problem is that the categories without any values are hidden by default and there seems to be no easy way to prevent it from happening.

Is there a good solution for this?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Impactful Individual
Impactful Individual

Re: Show column even if value is blank

I think there's an option on the visualization options to "show values with no data" I'm on my phone or I'd try to show a screenshot.
Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂

View solution in original post

7 REPLIES 7
Highlighted
Helper II
Helper II

Re: Show column even if value is blank

A workaround I just found was to create a Measure that returns 0 if blank for the value, like this:  

IF(ISBLANK(value); 0; value) 

 However, the same method does not seem to work for regular/calculated columns.

Please let me know if there are other ways though.

Highlighted
Impactful Individual
Impactful Individual

Re: Show column even if value is blank

I think there's an option on the visualization options to "show values with no data" I'm on my phone or I'd try to show a screenshot.
Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂

View solution in original post

Highlighted
Helper II
Helper II

Re: Show column even if value is blank

Ah, I had totally missed that option. Exactly what I was looking for, thank you!

Highlighted
New Member

Re: Show column even if value is blank

I am unable to find that option in my report.

Can you please share with me the screenshot where the option is available?

Highlighted
New Member

Re: Show column even if value is blank

I am unable to find that option in my report. 

Can you please share with me the screenshot where that option is visible?

Highlighted
New Member

Re: Show column even if value is blank

Unable to find that option in my report .

Can you share a screenshot where that option is visible?

Highlighted
New Member

Re: Show column even if value is blank

On the visualisations pane, once a field is dropped into the axis section there is a small downwards arrow. Click this and the option is near the bottom of that list. 

PowerBI_ShowColumns.PNG

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors