Comma in value

[Anonymous]

Hi,

I am using a Card visualization to display a value, I have managed to concatenate $ in the total sum(i.e $"&calculate(ROUND(SUM(Table1[Net]),0)))

But I also require the value to be included with Commas as below

Actual                                   Expected

$1526501                             $1,526,501

Thanks,

Ravi

[Phil_Seamark · Accepted solution]

Have you tried leaving the $ off and formatting the measure using the format functions on the ribbon?

[Anonymous]

Thanks Phil, as you sugessted I applied the direct formating for the measures and it works fine.