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

c935c59d 6f0e-48ab-b20f-c46403545b3e 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

d3ba6a7f ca6f-47b9-9bc2-d4705ddbe285 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

ca888cdd a108-409d-b781-9eaff1569e87 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

7abb8775 d9c4-48da-adea-ffc894c4987f 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

dac2d588 771b-ea11-a811-000d3a8f066e 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

42015153 d599-4f8e-abf1-cffe57e84311 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

6b6debf3 831c-48e4-8a39-911da48d26d9 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

08fc0117 944f-4ffb-9098-18d929dc8fce on 05 Jul 2020 22:21:53

RE: conditional formatting in tables

please expedite it is critical

marcelo's profile image Profile Picture

f2890e48 215c-4341-8900-ebf149ffb2fd 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

876b00d3 d66e-41c2-b657-e4a00b8f0f71 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?