cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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).

 

PBI_Date_H.pngPBI_Date_S.png

 

Any thoughts would be appreciated.

6 REPLIES 6
v-cherch-msft Super Contributor
Super Contributor

Re: Change language date hierarchy field

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Change language date hierarchy field

Thanks for replying.

Have already tried to install english version. 

Going to try the other solution.

 

Thanks

v-cherch-msft Super Contributor
Super Contributor

Re: Change language date hierarchy field

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Change language date hierarchy field

Hello Cherie,

 

Haven´t tried yet, but I know this is going to work. 

I was trying to avoid this solution, but will have to do it.

 

Thanks

 

Anonymous
Not applicable

Re: Change language date hierarchy field

Hello

Happy new year!

 

I thougth the solution would work, but it didn´t.

I have created a new tab with dates and column headers in english. Formatting is in english also.

I´m running Power BI in english.

But as the system creates the dates hierarchy, it creates in portuguese.

 

Don´t know what else I have to do to solve this problem.

 

image.png       image.png

 

 

Thanks

image.png         image.png

v-cherch-msft Super Contributor
Super Contributor

Re: Change language date hierarchy field

Hi @Anonymous

 

You may try to create the hierarchy manually: 1. Click 'New hierarchy 2. Add the columns to the hierarchy.

1.png

2.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 44 members 1,041 guests
Please welcome our newest community members: