CONDITIONAL FORMATTING BASED ON TWO CALCULATED MEASURE

[dokat]

Hi,

Is it possible to have conditional formating based on two calculated measures in row card.

Hi,

I have a row card that has YoY % growth calculation as a measure. In addition to YoY growth i'd like to add a condition if the number is greater than >0% highlight data in green if it's below 0 highlight in red.

Current formula

if ( (CALCULATE(('P&L'[2021]), 'P&L'[P&L] in { "Customer NS"})/CALCULATE(('P&L'[2021]), 'P&L'[P&L] in { "Customer NS"})-1)

>

(CALCULATE(('P&L'[2020]), 'P&L'[P&L] in { "Customer NS"})/CALCULATE(('P&L'[2020]), 'P&L'[P&L] in { "Customer NS"})-1), Green Format otherwise red.

Is it possible to do this?

[amitchandak · Accepted solution]

@dokat , You can create color measure with different conditions and use that in conditional formatting using field value option

color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0 && [Net Sales YTD] > 0 , "green",
_change = 0, "blue",
_change < 0, "red"
)

or

color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0 && not(isblank([Net Sales YTD]))  , "green",
_change = 0, "blue",
_change < 0, "red"
)

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4