Showing a color if a value is present in at least one cell

[IlMoro]

Hi,

I have a column with "yes" and "no" data.

I would visualize a green box normally but if there is at least one "yes" then the box have to turn red. I need just color, no text or whats so ever inside the box.

Thanks for any support

[hashtag_pete]

Hello @IlMoro 

you can find some help in this article. 

Tips on displaying icons based on field values in ... - Microsoft Power BI Community

Best regards

hashtag_pete

[IlMoro]

Hi @Greg_Deckler 

I tried to read the article but I cannot get into it and I don't think it fits with my easy need.

I just need a "card" that can change color due to two basic conditional formatting rules.

I tried "Advance Card" visualization but it does not work.

[Greg_Deckler]

@IlMoro If you want a specifici solution, then you are going to need to provide specific information.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[IlMoro]

Hi @Greg_Deckler , I already posted everything down below.

[Greg_Deckler]

@IlMoro Create a flag measure that returns 1 or 0 depending on color. Create a measure like: Measure = " ". Put said measure in table and base background conditional formatting on your flag measure. 

There are lots of other ways as well.

[IlMoro]

May you be please more specific? Not an expert at all...

[Greg_Deckler]

@IlMoro No, I can't because you haven't explained things very well. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[IlMoro]

Here is the example:

[hashtag_pete]

Hi,

given your example, I would create an additional column next to your Column1, saying 

Column2 = if([Column1] = "yes", 1, 0)

then you can make a measure 

Indicator = sum([Column2])

place this measure in your card and make it conditional: if Indicator >0 then red, else green

Does that help?

[IlMoro · Accepted solution]

Hi @Greg_Deckler  and thanks for the tips however I was searching something more easy without the need of creating new columns.
I found it in just creating the card --> Format your visual --> Effects --> Background --> Color --> Conditional Formatting "FX icon".
Eventually it can be applied also to the text thesame conditional formatting to let the whole card have the same color.