Conditional Formatting

cingram11 - You're not giving us a lot to work with here. A screenshot, some data to work with would be helpful.

Take some time to understand the below screenshot. I've tried to colour code it so I can explain it easier.

• Create the measure that describes your rule. I've used a switch statement in this example. I don't have your data to work with and my data always evaluates to green, which is why the quantity in the matrix is showing in green.
• The light red sections (rows or columns) can't be conditionally formatted like this. Only the values (light green highlight) can be conditionally formatted in a matrix.
• Make sure you set the data type to text in your formatting measure.
• If you need to highlight your date and you need to use a matrix, you might be able to move your next order date to the values section and set the aggregation to 'Latest'.

This answer was not generated from AI because I know what I'm doing. 🤣

Hi cingram11 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you KNP burakkaragoz for the prompt response.

I have created a PBIX file using sample data to replicate the scenario.Please go through the attached PBIX file for your reference.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly.

Thank you.