Forum Discussion
Change language date hierarchy field
Hello all,
Need help to change the language from a date hierarchy field.
When I created the field, my PBI Desktop was in portuguese. Than, I changed to english because the audience requires the reports in english.
Now, everytime I use this field in a slicer, for exemple, the information is in portuguese.
Have tried changing LOCAL in Edit Queries, have tried to duplicate the column, have tried to format it in excel (database).
Any thoughts would be appreciated.
17 Replies
v-cherch-msftMicrosoft Employee
Hi Anonymous
You may try to create the hierarchy manually: 1. Click 'New hierarchy 2. Add the columns to the hierarchy.
Regards,
Cherie
I've had the same problem for a while now as well. The problem extends to both filters and visuals (charts in this case).
Any solution or workaround would be much appreciated!
I've had a same problem and I found a workaround by binning the dates into bins of the size 1 month. It's very simple: in the report view, right-click on the column and select "New group" and then select bin size. Hope this resolves your issue.
estou com o mesmo problema, porém meu está em puxando para o indioma russo, eu trabalho em portugues do Brasil. Como faço para solucionar?
- v-cherch-msft
Hi Anonymous
You may try to install the English version from here and test again. If it is not your case, you may create a date table and use the new hierarchy as tomerfaith said in below post.
https://community.powerbi.com/t5/Desktop/Change-language-in-date-year-month-day/td-p/75731/page/2
Regards,
Cherie
- v-cherch-msft
Hi Anonymous
Could you tell me if your problem has been solved? If it is,kindly mark my answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.
Regards,
Cherie
I think I found a solution !
First, in power query, right click on your date field and change (or check) the regional parameters.Then, I converted my field in a text field with the language I want (fr-CA in my situation)
And then, I reconverted my field in a date field and now my date is in French, like I wanted first !
Hierarchy is still in english but my date field, in powerbi, diplays in text (still in date format in power query)It can replace till we find an other solution
I hope it works for you too guys !
Finally, I apply my modifications, get back to powr query, deleted the steps and my hierarchy stays in French
Hi all,
Looks like no fix have been found on this issue..
Any one found another workaround ?
PS : I am using a powerBI created by a spanish colleague..
Best regards,
Hello,
Try this:
File > Options and Settings > Options > Regional Setting ( ensure the application language is to your preference)
Also
File > Options and Settings > Options > Data Load(under current file) > Uncheck the Time Intelligence save, then later check it.
It worked for me!!
