Forum Discussion

Dhania_BI's avatar
Dhania_BI
Frequent Visitor
5 years ago
Solved

Horizontal conditional formatting

Hello,

 

I attach a pbix file with a very simple matrix : https://www.dropbox.com/s/3i0k0is1b1pzgbz/test%20horizontal%20conditional%20formatting.pbix?dl=0

 

I need to evaluate each row of the matrix and see where the column "Quota" is bigger for one or other Brand (column "Marca"), then apply a different color where the cell "quota" is bigger.

 

Let me know if this is not clear. In the example, in row 1, the cell "30" should be in a different color because 30 > 10. In row 2, the cell "50" should be in a different color because 50 > 5.

 

Please take into account that in the real scenario I have more than 2 brands.

 

Any idea?

 

Thank you,

  • Dhania_BI Solution is attached. I have added 3 measures (in the solution) and also used conditional formatting to highlight the cuota.

     

    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.

2 Replies

  • Dhania_BI Solution is attached. I have added 3 measures (in the solution) and also used conditional formatting to highlight the cuota.

     

    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.