Forum Discussion

devGV_88's avatar
devGV_88
Helper I
2 years ago
Solved

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

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...

Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    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.
)

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    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.
)