Skip to main content

Power BI

Needs Votes

Conditional formatting for calculated columns

Vote (199) Share
's profile image

on 01 Jun 2016 23:18:29

The conditional formatting is a great edition, however it only works with summarized values which is a shame. It would be fantastic if conditional formatting can be applied to calculated columns, which in my opinion is more logical. For example when converting values into percentages.

Comments (8)
's profile image Profile Picture

Ed H-B on 31 Jan 2023 16:37:24

RE: Conditional formatting for calculated columns

Yes, it seems completely logical improvement to make.N.b. I notice that Conditional formatting already works for the other conditional formats: Background Colour, Text colour, Icons, so why not Data bars?

's profile image Profile Picture

Denis Gerber on 05 Jul 2020 23:34:27

RE: Conditional formatting for calculated columns

Please do that!

's profile image Profile Picture

Maikel de Bekker on 05 Jul 2020 23:26:14

RE: Conditional formatting for calculated columns

I'm also missing this option as this was a standard option in excel to be able to set conditional formating over percentages which where set over numbers in a pivot, for a Matrix I expect this also to be possible?

's profile image Profile Picture

Willem de Jonge on 05 Jul 2020 23:20:04

RE: Conditional formatting for calculated columns

This would be highly appreciated and very helpfull color scaling percent of row or column totals highlighting the range.

's profile image Profile Picture

David Wheeler on 05 Jul 2020 22:53:58

RE: Conditional formatting for calculated columns

lomg awaited visual enhancement

's profile image Profile Picture

Scott A on 05 Jul 2020 22:39:22

RE: Conditional formatting for calculated columns

This is a BASIC feature that should have been implemented a long time ago.

's profile image Profile Picture

Jon Toothill on 05 Jul 2020 22:33:30

RE: Conditional formatting for calculated columns

Agree this voting approach can be too spread out but its what we have. Conditional formatting on calculated columns is a needed extension for when summarising data to a RAG status - unless one can colour the table cells it makes for a lame visual

's profile image Profile Picture

Mike on 05 Jul 2020 22:28:43

RE: Conditional formatting for calculated columns

In my opinion this is related to https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15310341-conditional-formatting-in-matrix . I'm guessing that there are more conditional format related ideas in the 227 pages of ideas. This way of registering ideas is not efficient and does not benefit the speed of development and quality of the product.