Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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" )
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" )
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |