Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
joshua1990
Post Prodigy
Post Prodigy

Switch between Spanish and English naming

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 

1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
Community Support

Hi @joshua1990

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

The primary table is as below:

1.png

1.     We use parameter to achieve the goal.

We need to add a Language column as below:

2.png

Result:

3.png

Create Translate table and Header Table as below:

Translate Table:

5.png

Header Table:

4.png

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

Result:

6.png

Now we create a Language parameter:

7.png

Then we use this parameter to filter row:

9.png

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 :

10.png

Let's have a test:

As default:

11.png

We select Spanish in parameter:

12.png

Result:

The column names have changed to Spanish.

7.png

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

15.png

 14.png

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

Slicer Table:

1.png

AllName Table:

2.png

Then we build a Language Slicer:

3.png

We create a measure:

 

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

 

Result:

Select English:

4.png

Select Spanish:

5.png

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

6.png

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.

View solution in original post

3 REPLIES 3
v-rzhou-msft
Community Support
Community Support

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
Community Support
Community Support

Hi @joshua1990

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

The primary table is as below:

1.png

1.     We use parameter to achieve the goal.

We need to add a Language column as below:

2.png

Result:

3.png

Create Translate table and Header Table as below:

Translate Table:

5.png

Header Table:

4.png

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

Result:

6.png

Now we create a Language parameter:

7.png

Then we use this parameter to filter row:

9.png

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 :

10.png

Let's have a test:

As default:

11.png

We select Spanish in parameter:

12.png

Result:

The column names have changed to Spanish.

7.png

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

15.png

 14.png

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

Slicer Table:

1.png

AllName Table:

2.png

Then we build a Language Slicer:

3.png

We create a measure:

 

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

 

Result:

Select English:

4.png

Select Spanish:

5.png

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

6.png

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
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.