Formatting Variable

[brianhackett5]

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. 

TOTALS =
VAR
       Price_List_Errors = FINANCIAL_KPIs_Link[PRICE LIST ERRORS]   Whole number
VAR
       Sales = FINANCIAL_KPIs_Link[SALES FIGURE]                             Currency (€)
VAR
       GP = FINANCIAL_KPIs_Link[GROSS PROFIT]                               %

RETURN

SWITCH(FINANCIAL_KPIs_Link[NUMBER],
       1, Price_List_Errors,

       2, Sales,
       3, GP)

[brianhackett5]

Thank you very much, that worked perfectly. 

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

[v-huizhn-msft]

Hi @brianhackett5,

Have you resolved your issue? If you have, please mark the right reply as answer, so more members benefit more from here. As the @vik0810 said, we can't add the conditional formatting directly, please try the solution he shared. And please feel free to ask if you have other issue.

Best Regards,
Angelia

[vik0810]

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())

[vik0810 · Accepted solution]

Yes, you can use FORMAT function.

SWITCH(FINANCIAL_KPIs_Link[NUMBER],
       1, FORMAT ( [Price_List_Errors], "#,##" ),
       2,  FORMAT ( [Sales], "#,##0 €" ),
       3, FORMAT(GP, "percent")
)