Skip to main content

Power BI

Under Review

Conditional Formatting - Whole Table Rows

Vote (2229) 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 (146)
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?

Andrew Trezise's profile image Profile Picture

Daniel Martin on 14 Sep 2023 15:17:30

RE: Conditional Formatting - Whole Table Rows

I cannot believe this feature is still not available. Please make it soon

Andrew Trezise's profile image Profile Picture

Austin Jennings on 06 Sep 2023 21:04:38

RE: Conditional Formatting - Whole Table Rows

This feature needs to be implemented soon. I'm just commenting for the algorithm if there is one on this page.

Andrew Trezise's profile image Profile Picture

Berker ÜSTÜN on 28 Aug 2023 07:23:13

RE: Conditional Formatting - Whole Table Rows

Row based conditional formatting is a must for our power bi project now, i wish PowerBI crew would consider this idea for us. Thank you

Andrew Trezise's profile image Profile Picture

Farhan Chaudhry on 22 Aug 2023 21:11:47

RE: Conditional Formatting - Whole Table Rows

Conditional formatting on an entire Table Rows based on one or multiple fields, would be a nice addition. It will increase developers productivity.

Merged Idea (1)