Forum Discussion
luizronsani
6 years agoRegular Visitor
Conditional formatting based on a measure and different criterias
Hello ! I have a table where the column "%" is a measure that is the percentage of incidentes that have met the target (Met/Count). There is different target number for each priority, for example...
- 6 years ago
Hi luizronsani ,
You can create a measure to make the formatting based on the % and the Priority something similar to the one below:
Condittional Formatting = SWITCH ( TRUE (); ( SELECTEDVALUE ( 'Table'[Priority] ) = "Critical" && [%] >= 0,95 ); "#75FF00"; ( SELECTEDVALUE ( 'Table'[Priority] ) = "Critical" && [%] < 0,95 ); "#E66C37"; ( SELECTEDVALUE ( 'Table'[Priority] ) = "High" && [%] >= 0,90 ); "#75FF00"; ( SELECTEDVALUE ( 'Table'[Priority] ) = "High" && [%] < 0,90 ); "#E66C37" )You just need to two lines for each of the priority and change the colours on the formaating to the ones you need, then use the field value on the conditional formatting..
Check the result attach.
Regards,
MFelix
MFelix
Super User
6 years agoHi luizronsani ,
You can create a measure to make the formatting based on the % and the Priority something similar to the one below:
Condittional Formatting =
SWITCH (
TRUE ();
(
SELECTEDVALUE ( 'Table'[Priority] ) = "Critical"
&& [%] >= 0,95
); "#75FF00";
(
SELECTEDVALUE ( 'Table'[Priority] ) = "Critical"
&& [%] < 0,95
); "#E66C37";
(
SELECTEDVALUE ( 'Table'[Priority] ) = "High"
&& [%] >= 0,90
); "#75FF00";
(
SELECTEDVALUE ( 'Table'[Priority] ) = "High"
&& [%] < 0,90
); "#E66C37"
)
You just need to two lines for each of the priority and change the colours on the formaating to the ones you need, then use the field value on the conditional formatting..
Check the result attach.
Regards,
MFelix
- luizronsani6 years agoRegular VisitorThank you very much MFelix! It worked perfectly! Regards, Luiz