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

sabrina on 05 Jul 2020 22:34:31

RE: conditional formatting in tables

please can we have conditional formatting in Matrix?

This is really a blocking point

marcelo's profile image Profile Picture

Vel on 05 Jul 2020 22:34:22

RE: conditional formatting in tables

Conditional Formatting defined on a column in table is not getting applied to its summary value, this makes life difficult. Please apply the conditional formatting to summary value as well.

marcelo's profile image Profile Picture

Miguel on 05 Jul 2020 22:34:06

RE: conditional formatting in tables

Can Power BI have a conditional formatting on one column but different rows?

marcelo's profile image Profile Picture

Matt Richards on 05 Jul 2020 22:33:26

RE: conditional formatting in tables

Why release a feature for 'Power BI' if the feature is still worse than can be achieved in excel

marcelo's profile image Profile Picture

Chad Thurston on 05 Jul 2020 22:31:47

RE: conditional formatting in tables

Can we have conditional formatting across rows based on one column like in Excel? Also value ranges to apply colors to?

marcelo's profile image Profile Picture

Power BI User on 05 Jul 2020 22:31:39

RE: conditional formatting in tables

Need this in Matrix too

marcelo's profile image Profile Picture

Power BI User on 05 Jul 2020 22:31:34

RE: conditional formatting in tables

Hi I have downloaded the latest version of Power BI, but unable to see the conditional formatting options under the Quick calc, please let help

marcelo's profile image Profile Picture

Chimene B on 05 Jul 2020 22:31:01

RE: conditional formatting in tables

Our customers have requested the conditional formatting as a selection of colour tabs as opposed to 2-3 colour hues. Can this be in the next update in 2016?

marcelo's profile image Profile Picture

Thenmozhi.Sampath on 05 Jul 2020 22:30:09

RE: conditional formatting in tables

Is this feature removed in August release? I have the August version loaded in my 64 Bit machine and I do not see the analytics feature enabled for table and am not able to do the conditional formatting

marcelo's profile image Profile Picture

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

RE: conditional formatting in tables

Please add conditional formatting for Matrices. I've been banging my head against the wall trying to recreate out dashboards from excel/powerpivot in power BI.