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

    c162c86b 8bf8-e811-a95c-000d3a4f33c1 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

    e49ba83f a8a0-4e60-bd1e-098667a25cd0 on 05 Jul 2020 23:17:10

    RE: conditional formatting in tables

    Doesn't format the Total value.

    marcelo's profile image Profile Picture

    fdd6c11b e8db-45fa-8fca-2553bb19b3e5 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

    faf7fdf2 e18d-454f-b198-7e37086913e5 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

    5e735800 867b-4543-81b0-9064047953bd 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

    2853e9af 33ed-405b-a2c5-c8324c4faab7 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

    d341cd41 ae73-46d3-ba63-e473d04bff3a 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

    246074fb 17b0-4153-a15f-ef5adfa08d9f 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

    15edc63c 64a0-418a-8b78-92bc4937edb7 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

    511e1f82 9fa8-4332-8759-ed906726e539 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