Solved: Is there a way to to suppress the columns with 0 v...

Anonymous · ‎03-13-2021

Hello, I have this clustered column chart that I want to show only the columns greater than 0. I tried adding a filter=greater than 0 to one of the columns but everything disappeared.

MattAllington · ‎03-13-2021

If your meaure returns a blank, it will not be displayed in the visual

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

Anonymous · ‎03-13-2021

I don’t want any blanks also, I just don’t want to display when 0, like it does not exist. For example, on Day 8, I only want the bar for 205.

MattAllington · ‎03-13-2021

If your meaure returns a blank, it will not be displayed in the visual

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

MattAllington · ‎03-13-2021

Zeros are displayed by default, blanks are not. Can you write your measure to display blanks instead?

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Is there a way to to suppress the columns with 0 value in a chart?

Helpful resources

Power BI Monthly Update - April 2025

NEW! Community Notebooks Gallery

Fabric Community Update - April 2025

How to Get Your Question Answered Quickly