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)
RE: Conditional Formatting - Whole Table Rows
This is definitely a feature that should be included in Power BI. I am migrating our call stats system from a crude Excel/VBA solution (fetching data from SQL) to Power BI and the only thing I'm stuck on is formatting the top/bottom 3 rows red/green respectively.
RE: Conditional Formatting - Whole Table Rows
Complete row format option should be available.
RE: Conditional Formatting - Whole Table Rows
Conditional formatting should work like in Excel where the user can designate a measure that is used as the condition for any column in the table / matrix. There could be a toggle to apply to entire row or specific columns
RE: Conditional Formatting - Whole Table Rows
How is this not a standard functionality?
RE: Conditional Formatting - Whole Table Rows
Surprises me that such a basic and obviously useful function is not implemented.
RE: Conditional Formatting - Whole Table Rows
Would be useful, but would need to be able to format based on information not in the table, i.e. I've got a monthly data table with a row for each day, and I'd like to highlight rows where we're not in work, which is a related column on my calendar table
RE: Conditional Formatting - Whole Table Rows
Much-needed feature!
RE: Conditional Formatting - Whole Table Rows
I'm surprised why they haven't implement this straight forward concept. Also, it will be nice if they allow to do conditional formatting on a field based on another field.
RE: Conditional Formatting - Whole Table Rows
Yes, fairly simple concept but would be very useful!
RE: Conditional Formatting - Whole Table Rows
I'd like to echo Tanmay's statement. I want to create a conditional format based upon a measure, and apply the format to the entire row while hiding the measure.
For example, I created a report which has various bits of info regarding various customer environments, including the last date we processed data for that customer. I created an Age measure to compare the last processing date to today's date. I want to color the entire row based upon that age measure, without actually displaying the age.