Forum Discussion
jkay
8 years agoAdvocate I
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