Forum Discussion
Conditional formatting min & max
- 1 year ago
Hi Anonymous , you can use the measure below as basis to create the conditional formatting, then apply it in the columns you want to have the formatting using the option 'Field value', as shown below:
Conditional Formatting = VAR _max_value = MAXX( ALLSELECTED('Table'[Supplier]), [Var.CA] ) VAR _min_value = MINX( ALLSELECTED('Table'[Supplier]), [Var.CA] ) RETURN SWITCH( [Var.CA], _max_value, "Green", _min_value, "Red" )
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro
Hi Anonymous , you can use the measure below as basis to create the conditional formatting, then apply it in the columns you want to have the formatting using the option 'Field value', as shown below:
Conditional Formatting =
VAR _max_value =
MAXX(
ALLSELECTED('Table'[Supplier]),
[Var.CA]
)
VAR _min_value =
MINX(
ALLSELECTED('Table'[Supplier]),
[Var.CA]
)
RETURN
SWITCH(
[Var.CA],
_max_value, "Green",
_min_value, "Red"
)
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro