Format Cells in Matrix Using Different Conditions and Table Showing Available Date

[bigmac025]

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, I would like to highlight it to red in that date column.  If the value for the agent in the fourth row is over 5, I would like to highlight it to red in that date column.  Each agent has a different threshold that I want the cell to be highlighted if it is over a certain amount in each date column.

I also want to highlight the Total cell for the date if it is over 15.

Is this possible?  I can easily setup conditional formatting but the threshold has to be the same value.  In this report each agent has a different threshold value.

Second question, I would like to create a table visual that shows when the agent's value in a cell is below the threshold.

For example, if you look at the agent on the second row, I would want to display in a table that the value under 8/6/2025 is under his threshold of 2.  This would exclude weekends.

Agent	Next Available Date for Work
2	8/6/25

Any help would be appreciated for both questions.

Thank you for your help in advanced.

Tim

[danextian]

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. 

[Ashish_Mathur]

Hi,

Share the download link of the PBi file.  Also, share a 2 column table with the threshold of each agent.

[bigmac025]

Here is the link to download file Information Technology Analytics.pbix

[Ashish_Mathur]

That takes me to a sign-in page.  Also, share a 2 column table with the threshold of each agent.

[bigmac025]

Hello,

Please try this link for download: https://www.dropbox.com/scl/fi/1xb51uftifv7d6gak0pgn/Information-Technology-Analytics.pbix?rlkey=pkr...

The threshold for each agent is in a 2 column table on the page (bottom left).

Thanks,

Tim

[Ashish_Mathur · Accepted solution]

PBI file attached.

Hope this helps.

[bigmac025]

Thank you Ashish!  This is perfect!

[Ashish_Mathur]

You are welcome.