Forum Discussion
conditional formatting rules depending on other value from different column
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?
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
2 Replies
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