Dynamic conditional formatting

[cottrera]

Hi I have a a performance report.

The facts table contains the following columns - Date, Team, SLA (Pass or Fail) the model contains a dates table with the following collumns - Date, Year , Month.  I also have a DAX measure % SLA pass

My report has a table visual that displays Month and my DAX measure

Month	SLA Pass (DAX measure)
Jan	100.00%
Feb	33.33%
Mar	75.00%
Apr	57.14%

The report page has slicers Year and Month

Year		Month
2022		March

My visual table has conditional formating set to colour the SLA Pass (DAX measure) colours based on the criteria I have set.

However we have just changed the threshold from 01/04/2022.

Is it possible to Dynamically set the conditional formatig colours for results before 01/04/2022 and then have a different set of colours for results after 01/04/2022? Like the example shown below.

Conditional format  < 01/04/2022

% SLA 100% = Green  

% SLA >=75% = Amber  

% SLA <75% = Red  

Conditional format  > 01/04/2022

% SLA 100% = Green  

% SLA >=50% = Amber  

% SLA <50% = Red  

thank you

Richard

[cottrera]

Hi  thank you for your quick response your DAX function works fine 😊

[amitchandak · Accepted solution]

@cottrera , You can create a color measure and use that in conditional formatting using field value option

Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) < date(2022,04,10) ,
Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .75 , "Amber" ,
"Red "
) ,
Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .5 , "Amber" ,
"Red "
)
)

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L