cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
gusly
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
austinsense
Impactful Individual
Impactful Individual

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

8 REPLIES 8
gusly
Helper II
Helper II

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.

austinsense
Impactful Individual
Impactful Individual

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 🙂

Unable to find that option in my report .

Can you share a screenshot where that option is visible?

I am unable to find that option in my report. 

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

I am unable to find that option in my report.

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

Anonymous
Not applicable

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

You are the best 🙂

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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors