Forum Discussion
Color Formatting with a boolean measure
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
3 Replies
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
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")
