Skip to main content

Power BI

New

Advanced conditional formatting (based on another metric/cell/dimension)

Vote (28) Share
's profile image

on 07 Mar 2017 23:10:49

HI,

I know there is a condtional formatting option available. However, it's to simple for my business case. I want to make a dashboard in which I can easily see if my results meet their target. The target is a changing metric, so I can't fill in a standard value (which is currently the case), but I would need to make the conditional formatting based on another metric/cell.
I would like to color my MetricA green if they are higher than MetricB. That's currently not possible. Also conditional formatting based on text or dimension is yet not possible. For example, I would like to turn every "Sold" status green. Is this something that's in progress already?