Switch between Spanish and English naming

[joshua1990]

Hello everyone!

i have a report where all legends are in English.

is there any chance to link that column name with a Spanish translation und two switch between two languages for the same report? 
It is just about the column name/ legends in the visuals or matrix 

beat regards 

[v-rzhou-msft]

Hi @joshua1990 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table or share me with your pbix file from your onedrive business.

Best Regards,

Rico Zhou

[v-rzhou-msft · Accepted solution]

Hi @joshua1990

Here I will provide you two ways that may help you.

The primary table is as below:

1.     We use parameter to achieve the goal.

We need to add a Language column as below:

Result:

Create Translate table and Header Table as below:

Translate Table:

Header Table:

Then we need to append Primary table(Table_Parameter) and Translate table:

Result:

Now we create a Language parameter:

Then we use this parameter to filter row:

Then we need to transform Header table. For more details you can watch the video form this link: https://www.youtube.com/watch?v=JJryD2dXVVw

After we set Header table as the Column name of Append1 :

Let's have a test:

As default:

We select Spanish in parameter:

Result:

The column names have changed to Spanish.

But the visuals will be broken, we need to fix the visual and build visuals again.

 

2.     We need to create two tables Slicer Table and AllName Table

Slicer Table:

AllName Table:

Then we build a Language Slicer:

We create a measure:

Measure 2 = 
var a = MAX(Slicer[Language])
return
SWITCH(a, "English",[M_EnglishName],"Spanish",[M_SpanishName])

Result:

Select English:

Select Spanish:

Note: We need build relationship between Table and AllName Table, or we will get a wrong result.

Note2:Due to we use a measure, we can not add measure into Legend. So this way is not applicable to the visual need Legend.

Currently, there isn't a simple way for you change the language of the column head.Please click the Idea link below and vote for this function. If this idea is not suitable for you, you can submite a new idea.

Idea Link: https://ideas.powerbi.com/ideas/idea/?ideaid=4b8536d7-9d79-4ab3-85e2-5329b375834f

If this still can't help you to solve the problem, please provide me more details about you table or share me with your pbix file.

You can download the pbix file form this link:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/tongzhou_qiuyunus_onmicrosoft_com/EfmNV3VHdV9JgJcJ...

https://qiuyunus-my.sharepoint.com/:u:/g/personal/tongzhou_qiuyunus_onmicrosoft_com/EfnmpsyOxKlOjesi...

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@joshua1990 you can achieve this by applying language pack using Tabular Editor (external tool)

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡