Color Formatting with a boolean measure

[Anonymous]

Hi all,

I have used conditional formatting but is not working properly on all the tiles as intended. It should only provide green and red but it also gives this middle color for some reason 

the column values are a measure (I converted the yes into 0 and 1): 

Convert_Trading_YesTo1 = IF(components_mkt[trading]="yes",1,0)

This is the formatting used

[amitchandak]

@Anonymous , Try rule based on this. you should able to give value based on that.

Or create a color measure like

Convert_Trading to color = IF(max(components_mkt[trading])="yes","green","red")

and use that with field value option

refer my video for steps: https://www.youtube.com/watch?v=RqBb5eBf_I4

[Anonymous · Accepted solution]

EDIT

Solved by substituting SUM in the Summarization with Max

----

For some strange reason, the format is working for the other columns but not for this one

Wrong result

Correct result

[Anonymous]

The rule value is NOT working. for some reason

For the columns which have yes/no, am I obliged to make a color measure for each column that I want to format?

Also, I tried using the SWITCH measure format below but it is not working. I can't the measure select it in the 

NA_AssetClass_Color = SWITCH(max('Connectivity Coverage analysis xlsx_https://iontradingcom sharepoint com/teams/F'[NA (North America)]),

"yes", "#71DF8C"

,"", "#E6E6E6","#FFD86C")