Conditional Formatting - From the second (based on the first) column to the following

[devGV_88]

Hello folks,

I'm trying to figure out how apply the conditional formatting in a table, but I need to avoid the first column.

The first one must be the base line to the second, and then, the second to the third....

When I apply the conditional, the first column show an icon as "Up", but this is the first value...

Is biger (Up) than which one?

The long story short.

I need the icons from the second column...

[parry2k · Accepted solution]

@devGV_88 you can easily do this by making a measure for the conditional formatting:

Color = 
IF ( 
    SELECTEDVALUE ( 'Calendar'[Year] ) = CALCULATE( MIN ( 'Calendar'[Year] ), ALLSELECTED ( 'Calendar' ) ) &&
    SELECTEDVALUE ( 'Calendar'[Quarter Number] ) = CALCULATE( MIN ( 'Calendar'[Quarter Number] ), ALLSELECTED ( 'Calendar' ) ),
    -100, --some random value to check in conditional formatting to not to do anything
    <<logic for conditional formatting>> --value that will show up or down arrow.
)