Forum Discussion

smjzahid's avatar
smjzahid
Helper V
6 years ago
Solved

Conditional Formatting entire ROW with background colors

How do I conditionally format entire ROW on a Table visual, I want to conditionally format the entire row (not column) with different colours based on a KPI Background column. The expected result is shown below.

 

I know as of now we cannot coditionally format a background for row in Power BI (please correct me). However, need to know if there is a workaround this to achieve result as per below image.

 

 

 

3 Replies

  • smjzahid there is no method to conditional format the whole row, you have to apply the same conditional formatting rules to each column in the matrix/table visual. Annoying, right? I think there is an idea on ideas forum, do vote for it.

     

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.

    • smjzahid's avatar
      smjzahid
      Helper V

      Yes, looks quite simple thing to implement from the Power BI team, quite frustrating