Forum Discussion

jkay's avatar
jkay
Advocate I
8 years ago

Matrix percentage conditional formatting

Hi,

 

Can someone pleasew confirm if this is currently a limitation of the product? I've got the following table with percentages based on measures using DAX like below. All I want to do is show positive percentages as green and negative as red. Is it possible?

 

Many thanks

 

Capex vs Budget % =
VAR __BASELINE_VALUE = CALCULATE(SUM('PM-Financials'[Capex]),filter ('PM-Financials','PM-Financials'[Scenario]="Budget"))
VAR __VALUE_TO_COMPARE = CALCULATE(SUM('PM-Financials'[Capex]),filter ('PM-Financials','PM-Financials'[Scenario]="Actual"))
RETURN
IF(
NOT ISBLANK(__VALUE_TO_COMPARE),
IF(__BASELINE_VALUE < 0,
-DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE),
DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)
))

 

No RepliesBe the first to reply