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

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?