Changing currencies and decimals and dots in Power BI

[jaryszek]

Hi Guys,

what is a best approach for providing reports for different regions all over the world (like USA, Poland, France).

When I import currency with a "." and changed type to number i got the error using polish regional settings (in Poland we have "," as number seperator). How it should be done? 

Import values as text and change them only on visual levels using DAX? 
Or specifying regional settings import features with culture within Changed Types in Power Query?

What approach you are using?
Best,
Jacek

[v-shamiliv]

Hi @jaryszek 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[jaryszek · Accepted solution]

Yes, you need to import english regional settings in current power bi file, save to pbip and it will be updated for all developer using bpip reports. 

Best,
Jacek

[lbendlin]

Keep in mind that the Power BI Service is first attempting to probe the browser's culture setting and trying to apply that. So keep your data in a generic format and let the browser do its thing.

The import settings are unrelated to this.

[jaryszek]

thanks! 

What does it mean in generic format? Using "." or ","?

Best,
Jacek

[lbendlin]

Whatever you as the developer need to do math on the numbers.