text comma separator
1 Topic
How to place a comma from an existing card formatted to text
Thanks to amitchandak for fixing my measure below, it works perfectly. nNow, the next task is I would like to have a comma separator whenver it says for example $1000.0M, and convert it to $1,000.0M. Here's the measure: Card graph = Var Total1 = CALCULATE(SUM('MasterData'[Sum1])*1000000) Var Total2 = CALCULATE(SUM('MasterData'[Sum2])*1000000) Var decimal = "0.0" RETURN SWITCH ( TRUE() , Total2 >= 1000000000 , CONCATENATE("$", FORMAT (Total1/1000000000, decimal & "bn")) , Total2 < 1000000000, CONCATENATE("$", FORMAT (COALESCE(Total1, 0)/1000000, decimal & "M")) , CONCATENATE("$", FORMAT (COALESCE(Total1, 0) , decimal) )) This measure will convert it to text so I'm unable to use the Callout Value functions in the Card Graph. Thanks in advance!Solved701Views0likes1Comment