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

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors