Matrix Visual - Conditional Formatting

[vwiles84]

I have a martix that has sales information as the value, year by column and Week number and day of week by rows. I'd like to add formatting to this visual that highlights the highest sales amount in the chart for by year. Ideally, I'd like a visual that show a darker color for the highest sales amount ever but by each year will be good.  I am not finding a good way to conditionally format the visual so it give me the color idicators like I can in excel. Any help is appreciated. 

Here is a picture of the matrix in question. 

[vwiles84]

Thank you for sending that. I reviewed and tried the dax measures but did not get a result. I am looking to idenfity the highest sales day when in the matrix when the day of the week, month and store are selected from the slicers.  I understand that creating a measure to calculate the MAX value would be the way to achieve this. However, i'm not sure how to get that data. I have tried a measure that just does MAX(table[actual]) but I am not able to add that measure to the conditional formatting. It isn't available for me to select for some reason.  Do you know why that measure isn't a field value the formatting can be based on?

[vwiles84 · Accepted solution]

I found this video and this gave me the solution I need. https://www.youtube.com/watch?v=FOZQ0L8JxwI 

[AnkitaaMishra]

Hi @vwiles84 , 
I have provided solution to similar problem in below post, please have a look once. 
https://community.fabric.microsoft.com/t5/Desktop/Conditional-Formatting-in-Matrix-Visual/m-p/402960...
Let me know if you need more help with writing DAX for your usecase. 
Also, it would be helpfull if you provide the expected ouput.

Thanks,

Ankita