Forum Discussion
Conditional Formatting based on rules with dynamic conditions from slicer selection
Hi Experts, I have a conditional formatting set in a Matrix based on rules which checks for the values in certain range and display traffic light icons accordingly. The screenshot is atttached be...
Hi,
As shown in the image, the threshold value ranges are directly used in the Rules and not stored anywhere in table. Until now all the Markets have been following the same threshold but now one of the Markets is going to follow a different threshold which i am not sure how to implement.
Keshavpooja in this case, i suggest you to create a calc column like below there you can define sepeate condition for market A and Other markets.
So you can code color green with 1 and yellow with 2 and red with 3 like below
Color_coding =
var _sla_va = 'Table'[SLA Fullment]
return
if ('Table'[Market] = "A" ,
SWITCH(TRUE(),
_sla_va>=0.9,1,
_sla_va>=0.5,2,
_sla_va>=0,3
),
SWITCH(TRUE(),
_sla_va>=0.8,1,
_sla_va>=0.7,2,
_sla_va>=0,3
)
)
then in the conditional formatting of your matrix you can put condition like below
below is the final output
i have attached the pbix file for your reference as well.