Forum Discussion

brianhackett5's avatar
brianhackett5
Helper 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. 

 

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)

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

4 Replies

  • vik0810's avatar
    vik0810
    Resolver V
    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
    Helper 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
      Resolver 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())
    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      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