Power BI

Completed

Conditional Formatting based on a different measure

Vote (335)

on 29 Nov 2016 04:54:52

I would like to be able to format a column in a table or matrix based on values of a different measure, or based on values of the same measure in a different row of the table.
Examples :
1. Conditional formatting of sales amount based on the value of sales amount last month(green if higher, red if lower etc.).
2. Conditional formatting of sales amount based on sales goal(higher/lower than goal, and how far from target)

Administrator on 09 May 2018 06:02:16

Glad to report that we've now shipped this feature as part of our May update! https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#conditionalFormatting

Comments (29)

Comments (29)

a57e481a f760-49c8-924c-b09a0cca670e on 05 Jul 2020 23:15:41

RE: Conditional Formatting based on a different measure

This would be highly used feature in our environment, MS please consider this!

f93db4e6 f311-45fb-8754-72b611fa2a9b on 05 Jul 2020 23:15:17

RE: Conditional Formatting based on a different measure

Please reconsider! Pleaaaaaase!

09a45ac8 2ad5-4f7c-865c-94f41f74ce3b on 05 Jul 2020 23:13:53

RE: Conditional Formatting based on a different measure

It really is completely unacceptable that clearly Microsoft has not made this a priority, since this request has been known for two years now.
Migrating reports from other platforms that dó have proper conditional formatting, i.e. based on another column and other datatypes, not just numeric.
I am in the middle of a migration effort to Power BI and now have to let users know they will lose the current conditional formatting. Not a great way to sell a new solution.
Fix this Microsoft, it's fundamental to any reporting environment, even if I have to program code to realize this, as in SSRS, which is also pretty primitive but at least it works.