Forum Discussion
Condition row matrix color
Hi Everyone, i got this code ColorRow = SWITCH(TRUE(), Str_CE[Voce]="Product1","#F1F1F1", Str_CE[Voce]="Product2","#F1F1F1", Str_CE[Voce]="Product3","#F1F1F1", ...
amitchandak
Super User
Super UserAnonymous , Create a measure not column
ColorRow =
SWITCH(TRUE(),
Max(Str_CE[Voce])="Product1","#F1F1F1",
Max(Str_CE[Voce])="Product2","#F1F1F1",
Max(Str_CE[Voce])="Product3","#F1F1F1",
"WHITE"
)
It should work for 0. It will not work for blank
in fact, the values are blank or text "-", is there any way?
- v-easonf-msft
Community Support
Hi, Anonymous
Can you share sample data to further illustrate?
Best Regards,
Community Support Team _ EasonThis is the example file:
https://drive.google.com/file/d/1smjD5FpyRkCgw9m5b1C0tfO5KaC1XGls/view?usp=share_link
