Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

Conditional formatting with measure as rule

Hello. I have a table with a calculated numeric column, and I want to conditionally format it based on a measure. That is, for each case, if the value of the column is greater than that of the measu...
Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

Hi Syndicate_Admin 

You can create a "flag" measure that will check your condition and return 1 /0.
For example :

Flag condition = if(SELECTEDVALUE('Table'[column])>[measure test],1,0)
and then based on this measure modify conditional formatting:

Link to a sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly