Forum Discussion

devGV_88's avatar
devGV_88
Icon for Helper I rankHelper I
3 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 seco...
Need Help
  • parry2k's avatar
    parry2k
    3 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.
)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 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.
)