Skip to main content
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: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
482 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 an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Message 4 of 4
453 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
459 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 an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Message 4 of 4
454 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 an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Message 2 of 4
479 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

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

View All