topic Re: conditional formatting rules depending on other value from different column in Desktop

conditional formatting rules depending on other value from different column

Anonymous — Wed, 09 Mar 2022 11:30:49 GMT

I am wondering if it is possible to get the rules from background conditional formattting depending on a value from another column.
So as you can see under neath I got these rules for a specific table. When the value is less than 0.85 the colour becomes red and when the value is greater than 0.85 it becomes green. I want this values(0.85) depending on a specific column. I want it to depend on the column 'Doelstelling'. So as you can see the values at 'vertrek niet te laat' are all red, because they are all less than 'doelstelling' 85%, but I want the rule automatically change when the 'doelstelling'becomes another value. So when the 'doelstelling' becomes 75% and the 'vertrek niet te laat' changes remain the same, the rules must automatically change and the values from 'vertrek niet te laat' will change to green without me changing te rules, but the column 'doelstelling' change the rules. Is this possible with any function in PowerBi?

Re: conditional formatting rules depending on other value from different column

johnt75 — Wed, 09 Mar 2022 12:01:13 GMT

You can create a new measure which returns a value based on the comparison between the result and the target.

I'm not sure if doelstelling is a column or a measure, but if its a measure then something like

Background colour measure =
var currentValue = CALCULATE( [Vertrek niet te laat] )
var targetValue = CALCULATE( [doestelling] )
return IF( currentValue >= targetValue, 1, -1)

Then in your background formatting function you can set green if the value is 1 or red if it is -1

Re: conditional formatting rules depending on other value from different column

Anonymous — Wed, 09 Mar 2022 14:51:19 GMT

'doelstelling' is not a measure, but I made it a measure and now it works with your code, thank you!