Skip to main content

    Power BI

    Completed

    conditional formatting in tables

    Vote (892) Share
    marcelo's profile image

    marcelo on 21 Aug 2015 09:07:01

    It was implemented in charts but not in tables or matrixes.

    Administrator on 31 May 2016 23:23:27

    We released conditional formatting in tables with our May release of Power BI Desktop. Give it a try and let us know what you think. You can learn more about how to use it in our latest blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-update-feature-summary/.

    Comments (166)
    marcelo's profile image Profile Picture

    Anthony Merriwether on 05 Jul 2020 23:40:12

    RE: conditional formatting in tables

    This does not work properly. REALLY MICROSOFT.....

    marcelo's profile image Profile Picture

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

    RE: conditional formatting in tables

    Doesn't format the Total value.

    marcelo's profile image Profile Picture

    Salvatore Cagliari on 05 Jul 2020 23:13:07

    RE: conditional formatting in tables

    I have the problem that it doesn't work when only one row is in the table.
    As already mentioned here.

    marcelo's profile image Profile Picture

    Arun on 05 Jul 2020 23:09:38

    RE: conditional formatting in tables

    Why conditional formatting on tables are not working if there is only one row?

    marcelo's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:06:27

    RE: conditional formatting in tables

    As others have stated, I would also not consider this complete. True conditional formatting, as you know from your product Excel, should allow for highlight one or more cells based off of cell value or ranges. Providing a gradient off of minimum and maximum is truly not valuable.

    marcelo's profile image Profile Picture

    priya on 05 Jul 2020 23:04:45

    RE: conditional formatting in tables

    Does Conditional Formatting applied to total value of that column or not?
    Is that feature is available in Power BI desktop?

    marcelo's profile image Profile Picture

    Marcus Mattson on 05 Jul 2020 23:02:24

    RE: conditional formatting in tables

    same as the "entire row" comments preceding this comment.

    marcelo's profile image Profile Picture

    LS on 05 Jul 2020 23:00:14

    RE: conditional formatting in tables

    Ditto to Scott A below. Conditional Formatting in tables is not complete by any means.

    marcelo's profile image Profile Picture

    Scott A on 05 Jul 2020 22:59:31

    RE: conditional formatting in tables

    This is not complete by any stretch of the imagination. I do not want GRADIENTS in my conditional formatting. I just want any value over 25 to show up as red... not all sorts of shades of red starting BELOW 25 and higher. Ridiculous implementation of a standard and basic feature.

    marcelo's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:58:42

    RE: conditional formatting in tables

    When I right clicked on value the conditional formatting option did not appear - also it would be awesome if I could format an entire row based on one cell value - I am using as a forecast report from CRM and want commit to be green, upside yellow, all others none