Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
bjnodello
Helper II
Helper II

Conditional Formatting with Blank Values

Hello All,

 

Does anyone have and tips/tricks for dealing with blank values and conditional formatting?  It appears to be treating the entry as "0" and I would like it to be ignored.  

 

Thanks,

 

Brett

1 ACCEPTED SOLUTION
bjnodello
Helper II
Helper II

Thanks @v-yulgu-msft and @SwaroopRoyM,

 

I may not have been clear what I was asking.  Here are the settings I have for a set of table values in Power BI Desktop:

 

conderror 2.PNG

Note, in the screenshot below the blank value is shaded the same as the 0.  I would like the blank values to be ignored.  I am not aware of a way to use an IF statement to conditionally format in Power BI Desktop.  Is this really possible? If so can you provide additional details please?

 

conderror 1.PNG

 

Thanks,

 

Brett

View solution in original post

8 REPLIES 8
YukiK
Impactful Individual
Impactful Individual

You can definitely work this out by assigning values to blank values like others are suggesting, but you can also set a specific color as default formatting for conditional formattings, which worked my for case where I wanted blank as the same color as zero.

bjnodello
Helper II
Helper II

Thank you @SwaroopRoyM and @Sean.  This is one of many measures in the table so unfortunately, hiding blanks won't work as the other measures will not be blank.

Hi @bjnodello,

 

As you mentioned in the original post, currently the conditional formatting cannot distinguish blank value separately. So, unfortunately your requirement cannot be achieved now. You can submit a wish to Microsoft at this page: https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Thanks,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bjnodello
Helper II
Helper II

Thanks @v-yulgu-msft and @SwaroopRoyM,

 

I may not have been clear what I was asking.  Here are the settings I have for a set of table values in Power BI Desktop:

 

conderror 2.PNG

Note, in the screenshot below the blank value is shaded the same as the 0.  I would like the blank values to be ignored.  I am not aware of a way to use an IF statement to conditionally format in Power BI Desktop.  Is this really possible? If so can you provide additional details please?

 

conderror 1.PNG

 

Thanks,

 

Brett

Sean
Community Champion
Community Champion

Uncheck "Show items with no data" like this...

 

Show Items with No Data.png

Hello Brett,

 

If you don't want to see the "blank" value in the visual, you can do that by having this column as visual level filter. Once you have this column as visual level filter, go to "advanced filtering" option and choose "is not blank" option.

 

Hope this answers your query.

 

Thanks,

Swaroop

v-yulgu-msft
Employee
Employee

Hi @bjnodello,

 

In your scenario, what data source did you use to import to PowerBI desktop? In my test, I didn't get "0" value when I import blank values. Would you please provide some sample data so that we can reproduce your issue and give you more advice? 

 

Thanks,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SwaroopRoyM
Helper II
Helper II

Hi, You can use IF condition to look for "blank" and do the necessary formatting. Thanks, Swaroop

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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