DAX Measure formatting to have thousands separator (comma) in visual

[iosiflupis]

Hello all,

I have the following DAX Measure:

Total Deplaned Cargo =
VAR TotalDeplaned =
SUM(Cargo_Numbers[Ameriflight Deplaned]) +
SUM('Cargo_Numbers'[American Deplaned]) +
SUM('Cargo_Numbers'[Southwest Deplaned]) +
SUM('Cargo_Numbers'[United Deplaned])
RETURN
INT(TotalDeplaned)

When I put this in a Line Chart and add the Data labels none of the labels have the thousands comma separator. I have tried multiple ways to get the comma to show. I have tried formatting in the DAX, I have tried to format the underlying data in the table, and I have tried the Format tool and Data Label.

I even resorted to ChatGPT without any luck.

Does anyone know how I can do this while keeping the measure formatted for Whole Number?

Thank you,

Joseph

 

[GraH]

Hi,

It should work like this.

I made some dummy data, a list of decimals numbers and formatted the column in the data model as whole number with thousands separator (I'm European so that's a "." not a comma ','). Did you do this for all the columns inside the measure?

Same for the measure

On a chart (the line chart does not mean anything) the labels work per default.

The question is, how does the label number shows up at your end?

 

[iosiflupis]

GraH,
Thank you for the help. What I was forgetting was to set the 1000's separator in the actual measure to be on. Your comment helped me to realize that I forgot that simple, easy, step!

 

[GraH]

Glad to read it was a quick fix. Thanks for the feedback.