Hierarchy Title in many languages

[BenNguyen]

Dear Team,

I have one issue with the hierarchy title in the bar chart.
I have 4 levels from Country - BU - Department - Cost center

When I drill-down to next level, Power BI title will automatically change to that level. "by country", "by BU", etc.

The problem is:
When my users are in other country like Germany, the title will change to German except the levels in English
--> it doesn't look consistent at all

Can we implement the title completely in one language by measure? or are there any ways else?

Looking forward to your reply.

Thank you so much for your support!

Best regards

[BenNguyen]

Hi @Idrissshatila @SanKing , I have tried all the settings to English

1. Settings in the Global and Current File

2. The language setting in Workspace is also set to English

But the word "by" is still changed to "nach" when users are in Germany

I also tried the following DAX:
hierarchy title = "users counts by " & SWITCH(TRUE(),
ISINSCOPE('User_Transaction'[country]),"country",
ISINSCOPE('User_Transaction'[business unit]),"business unit", ISINSCOPE('User_Transaction'[department]),"department",
ISINSCOPE('User_Transaction'[cost center]),"cost center", "")
--> And the title turns to blank by the end "user count by "
--> Seems like Power BI does not understand my DAX

Could you please advice another solution?
Thank you.

[SanKing]

Hi @BenNguyen ,
I had the same issue, but due to some differences in each of the country that I create reports for I was forced to create separate reports.

Maybe this link will help you https://community.powerbi.com/t5/Desktop/How-to-create-Multilingual-Report-in-Power-BI/m-p/599696.

[Idrissshatila]

Hello,

You could try to specify the regional settings in the power bi desktop.

If I answered your question, please mark my post as solution, Appreciate your Kudos!

Follow me on Linkedin