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