Matrix conditionally format each column independently

Dear  elgato ,

Please follow the below steps:

Create Measures for Each Column: For each column (e.g., CR 01, CR 02), create a DAX measure to calculate the dynamic color. For instance:

CR01_Color = 
VAR MinValue = CALCULATE(MIN([CR 01]), ALLSELECTED('Table'))
VAR MaxValue = CALCULATE(MAX([CR 01]), ALLSELECTED('Table'))
VAR CurrentValue = [CR 01]
RETURN
    SWITCH(
        TRUE(),
        CurrentValue <= MinValue, "#FF0000",
        CurrentValue >= MaxValue, "#00FF00",
        "#FFFF00"
    )

Repeat this for all other columns (e.g., CR02_Color, CR03_Color).

Apply Conditional Formatting:

1. Open the Format Visual pane.
2. Locate the Conditional Formatting settings for the matrix.
3. Add Background Color formatting for each measure (CR 01, CR 02, etc.).
4. Choose the field value option and reference the appropriate color measure (e.g., CR01_Color).

Ensure Hierarchical Independence: Modify the DAX measures to account for the context of hierarchy levels, such as Year, Month, or Day. For example:

CR01_Year_Color = 
VAR MinValue = CALCULATE(MIN([CR 01]), ALLEXCEPT('DateTable', 'DateTable'[Year]))
VAR MaxValue = CALCULATE(MAX([CR 01]), ALLEXCEPT('DateTable', 'DateTable'[Year]))
VAR CurrentValue = [CR 01]
RETURN
    SWITCH(
        TRUE(),
        CurrentValue <= MinValue, "#FF0000",
        CurrentValue >= MaxValue, "#00FF00",
        "#FFFF00"
    )

Replace the context of the calculation to work at the desired level of the hierarchy (Year, Month, or Day).

Dynamic Solution for Large Columns: Instead of creating multiple measures, use a dynamic measure approach:

Dynamic_Color = 
VAR Column = SELECTEDVALUE('Columns'[ColumnName])
VAR MinValue = CALCULATE(MIN([ColumnValue]), ALLSELECTED('Table'))
VAR MaxValue = CALCULATE(MAX([ColumnValue]), ALLSELECTED('Table'))
VAR CurrentValue = [ColumnValue]
RETURN
    SWITCH(
        TRUE(),
        CurrentValue <= MinValue, "#FF0000",
        CurrentValue >= MaxValue, "#00FF00",
        "#FFFF00"
    )

Validation: Test the formatting across hierarchy levels to ensure it applies independently at each level (Year, Month, Day).

Performance Optimization: For larger datasets, simplify DAX expressions to avoid overloading the model.

Please mark this as solution if it helps you. Appreciate Kudos.

thank you fo reply!

But this solution doesn`t work properly for me

thank you anyway!