Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

format data depending the region

Good Morning, One question, if I develop a Power BI for example from Spain and upload it to the cloud service and share it with users within my organization who are from the US, the following happen...
Need Help
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Anonymous ,

 

you can change that by defining a custom format. Then this format will stay independent of the settings of each user:

Use custom format strings in Power BI Desktop - Power BI | Microsoft Docs

 

Like this you could format it as "dd.mm.yyyy" or something similar. Check the details in the documentation link above.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks you selimovd ,

But I don't want to have a predefined and fixed format.

What I want is that if a US user enters Power Bi service, he sees the date in American format.

If a user from Spain enters, see the date in Spanish format.

This works fine for date filters but not for table data.

Here is a basic example: i Created this report in Power BI desktop with Spanish format, i publish and now this is what i'm watching with US english browser (date slicers see well but table not):