cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper II

## Apply Conditional Formatting

Hello All,

I have a requirement where I need to apply conditional formatting Like,

If the date is in the past i.e < today then paint it green, if not then determine the formatting based on a Variance measure that i have created. If variance is <0 then paint it green, if >0 and <30 then Amber.

Regards

1 ACCEPTED SOLUTION
Community Champion

Hi @Kish1999 ,

You can create your measure as below:-

``````conditional_formt =
IF (
MAX ( table[your_date] ) < TODAY (),
"Green",
IF (
[variance] < 0,
"Green",
IF ( [variance] > 0 && [variance] < 30, "Amber" )
)
)
``````

or

``````conditional_formt =
IF (
OR ( MAX ( table[your_date] ) < TODAY (), [variance] < 0 ),
"Green",
IF ( [variance] > 0 && [variance] < 30, "Amber" )
)``````

Best Regards,
Samarth

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

2 REPLIES 2
Resolver IV

Here is another measure you can try with a SWITCH function:

``````FormattingMeasure =
IF (
MAX (Date[Date]) < TODAY(),
"Green",
SWITCH (
TRUE (),
[Variance] < 0, "Green",
[Variance] >= 0 && [Variance] < 30, "Amber",
"Other"
)
)``````
Community Champion

Hi @Kish1999 ,

You can create your measure as below:-

``````conditional_formt =
IF (
MAX ( table[your_date] ) < TODAY (),
"Green",
IF (
[variance] < 0,
"Green",
IF ( [variance] > 0 && [variance] < 30, "Amber" )
)
)
``````

or

``````conditional_formt =
IF (
OR ( MAX ( table[your_date] ) < TODAY (), [variance] < 0 ),
"Green",
IF ( [variance] > 0 && [variance] < 30, "Amber" )
)``````

Best Regards,
Samarth

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

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors