Skip to main content
Microsoft Idea

Power BI

Under Review

Conditional Formatting - Whole Table Rows

Vote (2144) Share
Andrew Trezise's profile image

Andrew Trezise on 14 Feb 2017 19:58:04

It would be great to be able to format full rows and not just specific columns in tables.

For example - I have a list of date driven tasks and would like to highlight the entire row where the task is overdue.

Comments (140)
Andrew Trezise's profile image Profile Picture

Adam Wilson on 22 Apr 2024 12:09:22

RE: Conditional Formatting - Whole Table Rows

This needs to be added ASAP, as this is a basic feature that exists in Excel and reporting consumers expect this to be in place.

Andrew Trezise's profile image Profile Picture

Nick Dyslin on 04 Apr 2024 16:23:25

RE: Conditional Formatting - Whole Table Rows

Please fix this! If you can do it in Excel, why can't you in Power BI? So silly.

Andrew Trezise's profile image Profile Picture

Amy Noll on 16 Feb 2024 02:29:20

RE: Conditional Formatting - Whole Table Rows

Wow wow wow. Really wild how this never made it in up until. Seems like such a basic feature to be able to highlight a whole row at minimum and at best highlight a row based on a condition in a column! Just putting my vote out there. Give the people what they want. We really do love you PBI

Andrew Trezise's profile image Profile Picture

Kris Horrocks on 12 Feb 2024 05:16:36

RE: Conditional Formatting - Whole Table Rows

As others have said before, this feature is data reporting 101 stuff. V1 shouldn't have gone out the door without it. Makes it far more tedious to implement and maintain than it should be.

Andrew Trezise's profile image Profile Picture

Paola Bianchini on 03 Jan 2024 12:36:27

RE: Conditional Formatting - Whole Table Rows

Hello,it would be great have the conditional formatting on the row.Right now the only available solution is to formatt each single cell elements.Quite expensive in terms of time if you have a table of 20 fields(as for client request).Hope you emplement it soon.TnksPaola

Andrew Trezise's profile image Profile Picture

Omar E on 06 Nov 2023 17:52:40

RE: Conditional Formatting - Whole Table Rows

This is a very much expected functionalityIt really reduces the ability of the reports to have a fully customizable formatting and the shown result is not very much appealingI mean the conditional formatting already exists, and you can already choose to apply it to values and/or to subtotals. So why not to headers as well?It's about the little things sometimes

Andrew Trezise's profile image Profile Picture

Daniel Hajde on 03 Nov 2023 00:07:21

RE: Conditional Formatting - Whole Table Rows

If you work with tables and/or have ever used Excel (anyone at Microsoft fall into that category?) you understand that although having the ability to highlight a single column is nice it is both unappealing and tedious to do multiple conditional formatting on each column individually. Simply from a design standpoint the ability to highlight the Entire Row is a must. Don’t take the good parts of older software and remove them from your flagship platform? It’s these “little” things that allow dedicated and loyal customers to consider your competitors software. Please bring this simple fix (should take your team a couple of hours to implement) to Power BI. It is amazingly overdue at around 6 years of requests! Make us all smile for once. Thanks.

Andrew Trezise's profile image Profile Picture

Prakash Thapa on 01 Nov 2023 13:57:11

RE: Conditional Formatting - Whole Table Rows

I was looking into the way to conditional format the entire row in table based on field value from one column and there is no such ability in power BI.We really need this feature in future updates, that would really help the users of Power BI.Thanks,Go PBI

Andrew Trezise's profile image Profile Picture

Kirill Lushkov on 12 Oct 2023 07:13:28

RE: Conditional Formatting - Whole Table Rows

3 years Microsoft. 3 years on this one.You added conditional formating for cell elements but not for row and columnd headers? Why? Really zero thought put into most of these visuals, no follow up on anything.Took you about 5 years to add text allignment options into score cards. This soft is a joke.

Andrew Trezise's profile image Profile Picture

Evonne Teh on 29 Sep 2023 00:55:19

RE: Conditional Formatting - Whole Table Rows

If the function not available, anyway to go about?

Merged Idea (1)