Forum Discussion

Roinka's avatar
Roinka
Icon for Helper I rankHelper I
7 years ago
Solved

Color visualization of numbers at column level

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). Howeve...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

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

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

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