Solved: Re: Horizontal conditional formatting

Dhania_BI · ‎12-17-2020

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,

parry2k · ‎12-17-2020

@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.⚡

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

Dhania_BI · ‎12-17-2020

Thank you very much, it worked on my real case!