cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mboomgaa
New Member

Formatting Background Color Conditional - Blank, Null, Empty, Zero?

Hello, I am try to conditionally format the background of my visuals based off of a measure then a scoring level of 0 (red), 5 (yellow) or 10 (green). I am having troubles conditionally formatting the background of my visuals that do not have data. In the Background>Color settings it has Default formatting options but only for blanks. When I view my visual as a table it is emplty so I believe that my data is not returning a blank and it is seen as a zero. 

 

Any advice on this? I can give more info if needed. Thanks!

 

Background>Color>fx Settings

 

mboomgaa_1-1619578848649.png

 

Empty Table

mboomgaa_2-1619578902433.png

 

1 ACCEPTED SOLUTION

@mboomgaa , with Range I doubt, but with Measure color and use that in conditional formatting with field value option

 

Switch( true() ,

isblank([measure]) , "red" ,

[measure] =0 , "Yellow" ,

[measure] <10 , "Orange",

"green"

)

 

 

refer

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://www.youtube.com/watch?v=RqBb5eBf_I4



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

4 REPLIES 4
amitchandak
Super User IV
Super User IV

@mboomgaa , Create a measure

New measure = [measure] +0

And use this measure in coditional formatting 

 

I think in that case if should pickup 0 .

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

0 can be an acceptable and scorable value from the measure so I want it to actually format the empty value as a blank like it indicates it will in the settings.

Hi @mboomgaa ,

 

Could you pls some sample data,or if possible ,your .pbix file would be better for us to test?

Remember to remove the confidential information.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

@mboomgaa , with Range I doubt, but with Measure color and use that in conditional formatting with field value option

 

Switch( true() ,

isblank([measure]) , "red" ,

[measure] =0 , "Yellow" ,

[measure] <10 , "Orange",

"green"

)

 

 

refer

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://www.youtube.com/watch?v=RqBb5eBf_I4



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - July 22, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors