Comma in value

Question

Hi,I am using a Card visualization to display a value, I have managed to concatenate $ in the total sum(i.e $"&amp;calculate(ROUND(SUM(Table1[Net]),0)))&nbsp;But I also require the value to be included with Commas as below&nbsp;Actual&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Expected$1526501&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $1,526,501&nbsp;&nbsp;Thanks,Ravi

phil_seamark · Accepted Answer

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

Forum Discussion

Comma in value

2 Replies

Related content

Drill Through with comma separated values

Remove trailing commas

Comma Separated Values

comma locale

Commas in Values