thousands separator are not the same in Data and Report

[Birch]

Hi All,

I'm strugling with the thousand separator. Right now it's NOT the same when I look in Data (import from Excel) and in my Report.

How can I get the Report to use the same as Data?

Region settings in PBI Desktop and Windows are correct.

[v-chuncz-msft · Accepted solution]

@Birch,

You may try using FORMAT Function and SUBSTITUTE Function.