Conditional Formatting for Matrix Table

[Amymai]

Hi all,

I need to format the values as Highest Number become green and lowest become red for each of the Seniority and Job function. Formatting should work on each columns. hence highest number for each column should be green and lowest would be red.

Please help!!

Thank you!!

Here is data sample

Here is data sampleHere is the matrix table

[v-jiascu-msft · Accepted solution]

Hi @Amymai,

Please download the demo in the attachment and refer to desktop-conditional-table-formatting#color-formatting-by-field-value.

1. Upgrade the Desktop to the latest version.

2. Create a measure.

ColorRules =
VAR columnMax =
    CALCULATE (
        MAXX (
            SUMMARIZE (
                'Table1',
                Table1[op account name],
                Table1[seniority],
                Table1[op job function],
                "MK", COUNT ( Table1[MktCount] )
            ),
            [MK]
        ),
        ALL ( Table1[op account name] )
    )
VAR columnMin =
    CALCULATE (
        MINX (
            SUMMARIZE (
                'Table1',
                Table1[op account name],
                Table1[seniority],
                Table1[op job function],
                "MK", COUNT ( Table1[MktCount] )
            ),
            [MK]
        ),
        ALL ( Table1[op account name] )
    )
VAR currentValue =
    MAXX (
        SUMMARIZE (
            'Table1',
            Table1[op account name],
            Table1[seniority],
            Table1[op job function],
            "MK", COUNT ( Table1[MktCount] )
        ),
        [MK]
    )
RETURN
    SWITCH (
        TRUE (),
        currentValue = columnMax, "Green",
        currentValue = columnMin, "Red",
        "Blue"
    )

Best Regards,
Dale

[Amymai]

Thank you so much!!!