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

    1a6ddf33 c787-4b4f-829f-85f9e516ccc7 on 05 Jul 2020 22:10:48

    RE: conditional formatting in tables

    like all said, with conditional formating we can distinguish figures and numbers within tables, appreciate if this feautre can be added

    marcelo's profile image Profile Picture

    45427444 2865-466f-8b05-1c36913af50a on 05 Jul 2020 22:10:43

    RE: conditional formatting in tables

    '+1 mandatory

    marcelo's profile image Profile Picture

    befba5ae f5b2-4c60-af7e-878b654878ef on 05 Jul 2020 22:09:11

    RE: conditional formatting in tables

    I would like to be able to colour format by columns, by value. Also a different colour format for the Totals column

    marcelo's profile image Profile Picture

    58439f09 5009-482a-8171-178e674d930c on 05 Jul 2020 22:09:04

    RE: conditional formatting in tables

    If this is planned, could we get an approximate delivery date? Personally, I am looking to apply colors to individual columns based on their values. Color based on a different value would be a really nice addition, but what is the trade off in terms of time to implement color based on the specific column's value vs. color based on a different value. Could this be implemented in an agile fashion? 1. Conditional color to columns based on their values. 2. Conditional color on columns based on a different value 3. Color changes to other elements of the table/matrix.

    Thanks!

    Brynn

    marcelo's profile image Profile Picture

    0455c8fd 40d9-4a54-96a4-f7dd9289282d on 05 Jul 2020 22:08:28

    RE: conditional formatting in tables

    Absolutely... a very important feature to make available.

    marcelo's profile image Profile Picture

    c70ffae1 f7cc-44c1-89b4-a875fa967f6c on 05 Jul 2020 22:08:08

    RE: conditional formatting in tables

    Color saturation should apply to individual columns but we should be able to choose and configure as many as necessary. It would be nice to color a column based on another column value but a comprehensive legend (like color scale) will need to be displayed.

    As for Excel-like conditional formatting, I think should stay in Excel.

    marcelo's profile image Profile Picture

    20fc1423 5a0c-4cf0-a7d2-971112762c59 on 05 Jul 2020 22:06:47

    RE: conditional formatting in tables

    Yes, this would be extremely helpful.

    marcelo's profile image Profile Picture

    eaf7dad9 343d-4a6d-8581-c039cf24594f on 05 Jul 2020 22:06:34

    RE: conditional formatting in tables

    A feature in Excel since forever... where is the Power in Power BI?

    marcelo's profile image Profile Picture

    97e4ba88 fd21-4440-bdad-70bcdcd8780d on 05 Jul 2020 22:06:29

    RE: conditional formatting in tables

    Applying color on individual column should be definitely a priority with conditional formatting in the same way as in Excel.

    marcelo's profile image Profile Picture

    0d57856b e578-4a0d-8651-7e99a175f88e on 05 Jul 2020 22:05:34

    RE: conditional formatting in tables

    We would definitely want to have this feature available