Forum Discussion
Anonymous
1 year agoNot applicable
Conditional formatting min & max
Hello, I would like to color the maximum data in a table in green and the minimum data in red. The table has 1500 rows and I want the formatting to be present on the "supplier" and "CA N" column, fro...
- 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
Anonymous
1 year agoNot applicable
Thank you Joao!