Skip to main content

Power BI

Needs Votes

Conditional Formatting - Whole Table Rows

Vote (951) Share
's profile image

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 (92)
's profile image Profile Picture

80196640 1c4a-4a08-afec-c3e44dae50e1 on 05 Jul 2020 23:37:55

RE: Conditional Formatting - Whole Table Rows

This feature need.

's profile image Profile Picture

88616f9c 09a1-4c11-a714-561df8e491d2 on 05 Jul 2020 23:37:31

RE: Conditional Formatting - Whole Table Rows

I need this too.

's profile image Profile Picture

4096ad3a 477b-4c0d-8947-88ad31e65581 on 05 Jul 2020 23:37:25

RE: Conditional Formatting - Whole Table Rows

row formatting based conditional cell values, text value based conditional formatting would be super awesome!

's profile image Profile Picture

dbf53eab c9e5-4871-9fdb-51e0854f2449 on 05 Jul 2020 23:37:15

RE: Conditional Formatting - Whole Table Rows

Yes this can be accomplished simply by adding a RowColor colum and setting the value to -1 every row that you want to color and 0 every other row. Then set conditional formatting by rule for each column using the sum of the RowColor column rule is greater than -2 and less than 0 set to desired color. This works great but each and every column of the table has to have this set exactly the same. Party on!

's profile image Profile Picture

fa812b0a 2b83-4f7d-8798-38e35808f3d2 on 05 Jul 2020 23:36:42

RE: Conditional Formatting - Whole Table Rows

Based on one of the Column Value I Want to Apply for the Entire row. Very Necessary feature to handle common Scenarios

's profile image Profile Picture

39a1c115 cc13-4e25-a89a-d9fa99ea8d89 on 05 Jul 2020 23:34:54

RE: Conditional Formatting - Whole Table Rows

totally agree! very necessary to have this feature or apply conditional format to a different column using different column/measure.

's profile image Profile Picture

956224c8 9de1-45c0-93c6-576ef681053b on 05 Jul 2020 23:34:46

RE: Conditional Formatting - Whole Table Rows

I need this feature to highlight rows which don't have up to date data.

's profile image Profile Picture

0bc9e69f c674-ea11-a811-000d3a579c38 on 05 Jul 2020 23:32:31

RE: Conditional Formatting - Whole Table Rows

This feature is necessary.

's profile image Profile Picture

d7b5035c fac3-4d52-b1b4-e9f37c8b0dc4 on 05 Jul 2020 23:31:59

RE: Conditional Formatting - Whole Table Rows

Basic feature that should be available.

's profile image Profile Picture

6d1bd2ac badf-4b5b-b60b-58e1acb7f271 on 05 Jul 2020 23:30:26

RE: Conditional Formatting - Whole Table Rows

Very useful to create heatmaps in pivot tables as well. A user cohort analysis would definitely benefit from this.