Forum Discussion
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
- parry2kSuper User
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.⚡
- Dhania_BIFrequent Visitor
Thank you very much, it worked on my real case!