Conditional Formatting

[davisaj2]

Is there a way to change the color of the columns (PD_QTY) based on the date? I'm looking to change the color for values in the future. When I click on the function button for the column color, I only get an option to count the date field, not based upon what the date it.

[v-yanjiang-msft · Accepted solution]

Hi @davisaj2 ,

According to your description, modify your formula to:

Change Qty Color =
VAR PDDate =
    MAX ( 'PD Hist'[DATE] )
RETURN
    IF ( PDDate < TODAY (), "#FF0000", IF ( PDDATE >= TODAY (), "#008000" ) )

In the visualization formatting pane>Columns>Colors, click the fx button.

Select the measure in the based on field.

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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

[davisaj2]

This worked! Thank you so much!

[otravers]

Apply conditional formatting by field value, i.e. use a DAX expression to set conditions and the corresponding colors:

https://powerbidocs.com/2020/11/02/conditional-formatting-by-field-value-in-power-bi/

[davisaj2]

Thank you for the link recommendation. I tried to replication the measure using a date instead of a number and Power BI didn't like the date field. Any suggestions?

Change Qty Color =

VAR PDDate = Date( 'PD Hist'[DATE] )

RETURN

IF (

PDDate < TODAY(),

"#FF0000", --Red color

IF (

PDDATE >= TODAY(),

"#008000" --Green Color))))