Skip to main content
Microsoft Idea

    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

    marcelo on 05 Jul 2020 22:22:35

    RE: conditional formatting in tables

    We should at least be able to format one field based on the value of another field. And format font colors too.

    marcelo's profile image Profile Picture

    Francois on 05 Jul 2020 22:22:34

    RE: conditional formatting in tables

    Will this feature be extended to Matrix visualization?

    marcelo's profile image Profile Picture

    Tom Benders on 05 Jul 2020 22:22:28

    RE: conditional formatting in tables

    Exactly Adrian, conditional formatting would be great.

    marcelo's profile image Profile Picture

    Nanda Kishore Reddy on 05 Jul 2020 22:22:23

    RE: conditional formatting in tables

    We have not heard anything after May 12th, please provide an update on when are you able to complete this feature or at least which stage are you in building this feature.

    marcelo's profile image Profile Picture

    David Brown on 05 Jul 2020 22:22:16

    RE: conditional formatting in tables

    This is blocking 3-4 active customer engagements for me. Please let me know when completed.

    marcelo's profile image Profile Picture

    Adrian Blidarus on 05 Jul 2020 22:22:13

    RE: conditional formatting in tables

    To me, this should behave like the conditional formatting in Excel.

    marcelo's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:22:11

    RE: conditional formatting in tables

    Please continue to focus on this. This would further enhance reporting to my customers.

    Thanks
    Shawn

    marcelo's profile image Profile Picture

    Amr Guenena on 05 Jul 2020 22:21:53

    RE: conditional formatting in tables

    please expedite it is critical

    marcelo's profile image Profile Picture

    Rj on 05 Jul 2020 22:21:50

    RE: conditional formatting in tables

    Hello Team,

    is there alternative method for custom color expressions, I want show color based value red, green or yellow.

    Thanks
    Rj

    marcelo's profile image Profile Picture

    Mike Ashton on 05 Jul 2020 22:21:44

    RE: conditional formatting in tables

    I'd like the ability to show, in the same column, negative numbers in red font, in brackets, with the positive numbers in black font without brackets. Both would be comma-separated.
    Can I check this is what you're expecting to put into the release?