cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smjzahid
Helper V
Helper V

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.

 

 

image.png

 

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @smjzahid ,

 

This is not supported for Power BI crrently, you may vote for this idea.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18159352-conditional-formatting-w...

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

Hi @smjzahid ,

 

This is not supported for Power BI crrently, you may vote for this idea.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18159352-conditional-formatting-w...

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
parry2k
Super User
Super User

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



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.

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

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors