Forum Discussion

Keshavpooja's avatar
Keshavpooja
Frequent Visitor
4 years ago

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...
Need Help
negi007's avatar
negi007
Community Champion
4 years ago

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. 

 

 

Keshavpooja's avatar
Keshavpooja
Frequent Visitor
4 years ago

Hi negi007 ,

 

Thanks a lot for your quick help with a solution. I had a look at your pbix file.

 

In my case the market field is not available in the same table on which matrix is built on. Hence i could not build Calc.Column. The market field is coming from another table and there is a slicer on Market where the user selects the market and runs the report. In such case, how can we capture the market selected by the user inside the calculation logic that you have provided.