Forum Discussion
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, 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
PBI file attached.
Hope this helps.
8 Replies
Hi,
Share the download link of the PBi file. Also, share a 2 column table with the threshold of each agent.
Here is the link to download file Information Technology Analytics.pbix
That takes me to a sign-in page. Also, share a 2 column table with the threshold of each agent.
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.
