Adding space on cards

[PDRTXRA]

Hi. I have several cards witha distinctcount from a column.

Lets say they show: 255160. How do I get the card to show 255 160? Meaning adding a space after the thousands.

Thank you.

Best regards.

[v-yangliu-msft · Accepted solution]

Hi  @PDRTXRA ，

Here are the steps you can follow：

1. Create measure.

Measure =
VAR Leng =
    LEN (MAX('Table'[Value]) )
VAR Thous =
    LEFT ( MAX('Table'[Value]), Leng - 3 )
VAR Rest =
    RIGHT ( MAX('Table'[Value]), 3 )
RETURN
    IF ( MAX('Table'[Value]) >= 1000, Thous & " " & Rest, Rest )

2. Result:

Please click here for the pbix file

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@PDRTXRA , I have not tested

give a format ### ###

or create a measure like format([measure], "### ###")