cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
MA14
Helper I
Helper I

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

‎03-13-2021 12:58 PM

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.

Capture.JPG

Labels:
Message 1 of 4
356 Views
0
1 ACCEPTED SOLUTION
MattAllington
MVP
In response to MA14

‎03-13-2021 01:29 PM

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


* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Message 4 of 4
327 Views
0
3 REPLIES 3
MA14
Helper I
Helper I

‎03-13-2021 01:12 PM

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.

Message 3 of 4
333 Views
0
MattAllington
MVP
In response to MA14

‎03-13-2021 01:29 PM

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


* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Message 4 of 4
328 Views
0
MattAllington
MVP

‎03-13-2021 01:03 PM

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


* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Message 2 of 4
353 Views
0

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

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!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

View All
Top Solution Authors
View All