Forum Discussion

KarelDeman's avatar
KarelDeman
Regular Visitor
4 years ago
Solved

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

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])

 

Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    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.

4 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      KarelDeman
      Regular Visitor
      4 years ago

      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.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      KarelDeman
      Regular Visitor
      4 years ago

      Worked like charm. Thank you very much!

       

      Result: