Forum Discussion
Solved
Format Cells in Matrix Using Different Conditions and Table Showing Available Date
Hello, I'm trying to format cell backgrounds in a Matrix based on the name in the first column and the value in the cell. For example, if the value for the agent in the first row is over 2...
PBI file attached.
Hope this helps.
Hi bigmac025
Ensure that in your data, there is threshold column for each agent. Create this measure
Highlight =
VAR _threshold =
SELECTEDVALUE ( 'table'[agent threshold] )
RETURN
IF ( [measure] > threshold, "red" )
In conditional formatting dialogue, selected field value among the options and select the measure above.
You can use hexadecimal, RGB or RGBA values instead of the word red for greater flexibility.