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

    damian terenzi 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

    Louis C. on 05 Jul 2020 22:10:43

    RE: conditional formatting in tables

    '+1 mandatory

    marcelo's profile image Profile Picture

    Power BI User 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

    Brynn 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

    Power BI User 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

    Raimana CHAMPS 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

    Power BI User on 05 Jul 2020 22:06:47

    RE: conditional formatting in tables

    Yes, this would be extremely helpful.

    marcelo's profile image Profile Picture

    Erik 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

    Power BI User 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

    James on 05 Jul 2020 22:05:34

    RE: conditional formatting in tables

    We would definitely want to have this feature available