Data language of dates

[Anonymous]

I would be very grateful if you could answer this question.

How can I transform the fields of the month? ( I currently have Spanish, BI destkop language ) to English, I can change it manually, but if I do so I am not ordered ( It does not follow the order of January, February, March, etc ) and when i visualize in my web browser wiht english language (power bi online) i also see it in spanish

Thank you in advance

[mwegener · Accepted solution]

Hi @Anonymous ,

the language depends on the model language.

To sort your month column look at this.

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-button

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

Hi @mwegener ,

Thank you but my problem is that my report is also created and above the dropdown you passed me in your screenshot it says that it only applies if the report is created.

[mwegener]

Hi @Anonymous ,

you can try this. 

1. Export your report as "Power BI template"

2. Open the Power BI template file with the free third party tool "Tabular Editor"

3. Change the Culture of the Model

4. Save the file and load it with Power BI Desktop

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support. 

[mwegener]

Hi @Anonymous ,

you can try to change the model language with Tabular Editor.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.