Conditional Formatting based on a Max value in the whole table (not just a row)

[KarelDeman]

I have the following data:

And would like to have conditional background gradient for each cell based on the highest value in the whole table - in this case it is "52".

How can I achieve this? 

Note: the current gradients (I specified for Sunday - Wednesday - I didn't bother doing it for the other days) are calculated on a measure I created to calculate the max value per row, but that is not what I want - see measure below:

Max Value = MAXX({MAX('Usage Calendar - All Events - 30 days'[0.0]), MAX('Usage Calendar - All Events - 30 days'[1.0]), MAX('Usage Calendar - All Events - 30 days'[2.0]), MAX('Usage Calendar - All Events - 30 days'[3.0]), MAX('Usage Calendar - All Events - 30 days'[4.0]), MAX('Usage Calendar - All Events - 30 days'[5.0]), MAX('Usage Calendar - All Events - 30 days'[6.0])}, [VALUE])

[parry2k · Accepted solution]

@KarelDeman first of all this is not the right format to work with, you should unpviot your data and from there everything should be super easy.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[KarelDeman]

Worked like charm. Thank you very much!

Result:

[parry2k]

@KarelDeman check this video and tweak it as you see fit https://youtu.be/TeeKcHjA8E0

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[KarelDeman]

Thank you Parry2k,

But my data is slightly different than mentioned in the video. My data looks like this:

I use Index column to make sure when I use a Table visual, the weeks are ordered correctly.