Skip to main content

    Power BI

    Under Review

    Conditional Formatting - Whole Table Rows

    Vote (2213) 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 (143)
    Andrew Trezise's profile image Profile Picture

    Michael Svien on 05 Jul 2020 23:03:31

    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.

    Andrew Trezise's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:01:10

    RE: Conditional Formatting - Whole Table Rows

    This is absolutely critical as I also have a need to show a row of date driven tasks that are overdue.

    Andrew Trezise's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:59:26

    RE: Conditional Formatting - Whole Table Rows

    good idea, i'm all for that

    Andrew Trezise's profile image Profile Picture

    Tanmay Andalib on 05 Jul 2020 22:58:59

    RE: Conditional Formatting - Whole Table Rows

    Yup this one is definitely needed as I received several request for this particular one. Also, since the formatting is based on numerical column, it would be great if I could also hide the numerical column as well while the row is being formatted based on that.

    Andrew Trezise's profile image Profile Picture

    Tanmay Andalib on 05 Jul 2020 22:58:59

    RE: Conditional Formatting - Whole Table Rows

    Yup this one is definitely needed as I received several request for this particular one. Also, since the formatting is based on numerical column, it would be great if I could also hide the numerical column as well while the row is being formatted based on that.

    Andrew Trezise's profile image Profile Picture

    arne helgesen on 05 Jul 2020 22:57:36

    RE: Conditional Formatting - Whole Table Rows

    Please add this functionality

    Andrew Trezise's profile image Profile Picture

    Jordan Closs on 05 Jul 2020 22:55:56

    RE: Conditional Formatting - Whole Table Rows

    This is absolutely necessary.

    Andrew Trezise's profile image Profile Picture

    Jason Anderson on 05 Jul 2020 22:51:36

    RE: Conditional Formatting - Whole Table Rows

    Yes! I don't know why this isn't available now, but this would be a great feature!!

    Andrew Trezise's profile image Profile Picture

    James Lovegrove on 05 Jul 2020 22:50:04

    RE: Conditional Formatting - Whole Table Rows

    YES!

    Andrew Trezise's profile image Profile Picture

    Srinivasan V on 05 Jul 2020 22:49:33

    RE: Conditional Formatting - Whole Table Rows

    I would like to vote for this feature as well

    Merged Idea (1)