Solved: Conditional Coloring

Anonymous · ‎06-02-2022

Hey Everyone,

I have a Power BI reort connects to Power Bi dataset as a live connection.

I have a table/matrix with financial numbers based on calendar months, and I would like to apply conditional background coloring:

* If month (number) is less (<) than current month then green if higher (>) then blue.

Is that possible to achieve?

VahidDM · ‎06-02-2022

Hi @Anonymous

Does your Model or Date Table have a Month Column? Do you use that column?

BTW, you need to add a measure and use that in Color Conditional formatting like this:

Color M =
VAR _A =
    MONTH ( TODAY () )
VAR _B =
    MONTH ( MAX ( date[date] ) )
RETURN
    IF ( _B < _A, "Green", "Blue" )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

FIFA World Cup - Medal Records

View solution in original post

VahidDM · ‎06-02-2022

Hi @Anonymous

Does your Model or Date Table have a Month Column? Do you use that column?

BTW, you need to add a measure and use that in Color Conditional formatting like this:

Color M =
VAR _A =
    MONTH ( TODAY () )
VAR _B =
    MONTH ( MAX ( date[date] ) )
RETURN
    IF ( _B < _A, "Green", "Blue" )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

FIFA World Cup - Medal Records