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.






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
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors