Skip to main content

Power BI

Needs Votes

Conditional formatting for calculated columns

Vote (183) 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 (7)
's profile image Profile Picture

f81cbcec 2f6b-47a8-a6a7-7575d522557e on 05 Jul 2020 23:34:27

RE: Conditional formatting for calculated columns

Please do that!

's profile image Profile Picture

f3a91c89 cc4b-4db9-a201-149c0f5b71d5 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

5c08d93d 4799-4156-9ec3-111405f4cc30 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

5c565a3a 0512-4b1d-9997-64f1d8522435 on 05 Jul 2020 22:53:58

RE: Conditional formatting for calculated columns

lomg awaited visual enhancement

's profile image Profile Picture

15edc63c 64a0-418a-8b78-92bc4937edb7 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

640c8c13 327c-47a2-81ec-a57754ab40b9 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

b1a92dec c272-447d-be93-5e4edf07a60e 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.