Forum Discussion
Number formatting showing up differently for different users
I'm not sure if this will work, but we use Tabular data sources and we force many of our measures to a specific format using the Custom format setting and then a FormatString. This seems to be unaffected by locale settings on user machines.
I suspect the issue is probably due to an interaction with the users locale and the server locale of the PBI-SSRS Server.
I haven't seen anywhere in PBI-Desktop that you can set the locale of the PBIX/Page/Measure like you can in SSRS reports
Anonymouswrote:I'm not sure if this will work, but we use Tabular data sources and we force many of our measures to a specific format using the Custom format setting and then a FormatString. This seems to be unaffected by locale settings on user machines.
I suspect the issue is probably due to an interaction with the users locale and the server locale of the PBI-SSRS Server.
I haven't seen anywhere in PBI-Desktop that you can set the locale of the PBIX/Page/Measure like you can in SSRS reports
I tried the custom format with format string option but that didn't help either. In IE it still shows $1,12,123 while in chrome it's $112,123.
I used $#,###,##0;($#,###,##0) in the format string.