Forum Discussion
Is measure context a thing?
I have lots of cards, each visualising a different measure and I am trying to conditional formatting for the background. I could create the following measure for each and every card: IF(CONTAIN...
themistoklis
Community Champion
Community ChampionAnonymous
Try something like the below formula:
Measure Value Color =
SWITCH(TRUE(),
VALUE([Measure Value1]) <=1,"#000000",
VALUE([Measure Value2]) <=15,"#000022",
VALUE([Measure Value2]) <=26,"#000033",
BLANK()
)
actually thinking about it, this won't work as it it won't cycle through all measures, the moment it hits true it will stop and ignore the following measures thus won't format the remaining backgrounds correctly.