Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Conditional formatting for calculated columns

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.
Status: Needs Votes
Comments
mikejarod
New Member
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.
jon_toothill
New Member
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
scott_allison
New Member
This is a BASIC feature that should have been implemented a long time ago.
DW
Advocate I
Advocate I
lomg awaited visual enhancement
willem_de_jonge
New Member
This would be highly appreciated and very helpfull color scaling percent of row or column totals highlighting the range.
mdebekke
Advocate I
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?
denis_gerber4
New Member
Please do that!
edward2
New Member

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?

fbcideas_migusr
New Member
Status changed to: Needs Votes