Color visualization of numbers at column level

[Roinka]

Hi,

I have a matrix of 2 rows and several columns.

Each cell present a diff value. I would like to visualize the values with colors. The colors should diverge from red (bad) to blue (good).

However on Some columns a large no is good (blue) and on others a large no is bad (red).

I would like the colors to be at column level, that is if in this column a high number is good than a high number would be blue and if in this column high is bad than high would be in red.

Category, revenue, customers leaving

CategoryA, 4% (red), 5% (blue)

CategoryB, 60%(blue), 80% (red) 

Is this possible?

[v-frfei-msft · Accepted solution]

Hi @Roinka ,

We can set the font color conditional formatting based on a measure as below.

Color =
VAR L =
    FILTER ( ALL ( 'table' ), 'table'[TYPE] = "LEVING" )
VAR R =
    FILTER ( ALL ( 'table' ), 'table'[TYPE] = "REVENUE" )
RETURN
    SWITCH (
        TRUE (),
        SUM ( 'table'[VALUE] ) = MAXX ( L, [VALUE] ), "#FF0000",
        SUM ( 'table'[VALUE] ) = MINX ( L, [VALUE] ), "#0000FF",
        SUM ( 'table'[VALUE] ) = MINX ( R, [VALUE] ), "#FF0000",
        SUM ( 'table'[VALUE] ) = MAXX ( R, [VALUE] ), "#0000FF",
        "#FFFFFF"
    )