Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
brianhackett5
Helper I
Helper I

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)

1 ACCEPTED SOLUTION
vik0810
Resolver V
Resolver V

Yes, you can use FORMAT function.

 

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

View solution in original post

4 REPLIES 4
brianhackett5
Helper I
Helper I

Thank you very much, that worked perfectly. 

 

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

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

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
Resolver V
Resolver V

Yes, you can use FORMAT function.

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.