Forum Discussion

brianhackett5's avatar
brianhackett5
Icon for Helper I rankHelper I
8 years ago
Solved

Formatting Variable

HIguys,    Just wondring if is possible to format variables depending on the result returned. I've highighted the desired format for each variable in red.    Thanks in advance for your help.    ...
Need Help
  • vik0810's avatar
    vik0810
    8 years ago

    Yes, you can use FORMAT function.

     

    SWITCH(FINANCIAL_KPIs_Link[NUMBER],
       1, FORMAT ( [Price_List_Errors], "#,##" ),
       2,  FORMAT ( [Sales], "#,##0 €" ),
       3, FORMAT(GP, "percent")
)
brianhackett5's avatar
brianhackett5
Icon for Helper I rankHelper I
8 years ago

Thank you very much, that worked perfectly. 

 

Is it possible to apply conditional formatting to individual variables (Red for bad, green for good)

vik0810's avatar
vik0810
Icon for Resolver V rankResolver V
8 years ago

Not directly. But you can use 2 cards and lay them one over the other. One is formatted to text red and bound to the measure like

IF(Variable < 0, Variable, BLANK())

 and the other card hast text green and the measure is vice versa

 

IF(Variable >= 0, Variable, BLANK())