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

b52a621d e847-4e38-9b42-c1146ed926d2 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

17d10afa 4532-4c67-a355-56f4f12c4742 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

ae4c37df c37a-4514-9e72-4f62d7b839a1 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

a107487d f767-4868-be0b-3d56811f2aa8 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

a2c25cf1 1677-4f3c-9ee9-3eb75d245fe2 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

2e7a8dea 90cb-450e-a1a0-6d83cc2bc0e4 on 05 Jul 2020 22:31:39

RE: conditional formatting in tables

Need this in Matrix too

marcelo's profile image Profile Picture

99e87b0e dcb0-49ac-86b1-f09b7118c6b3 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

6318d1ee bf62-45a2-9720-4206feb3154a 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

841b2ecc 4366-49a4-87bc-06f4677d34b8 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

cbd6b752 2e65-4335-8c8c-b2ac93524d93 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.