Forum Discussion
Translated slicer options
I am currently building a multilanguage report with the help of the Microsoft guidelines (https://learn.microsoft.com/en-us/power-bi/guidance/data-translation-implement-field).
I am struggling with getting the translated options to show when using a filter. It only shows me Product or Produkt as options in the "Product Names" slicer but I need Apples, Carrots and so on (if Language is English) or Äpfel, Karotten and so on (if Language is German/Deutsch).
Language = English
Language = Deutsch (German)
Data model
Translated Product Names table (field parameter):
Can anybody help?
I figured it out after carefully reading the documentation (https://github.com/PowerBiDevCamp/TranslationsBuilder/blob/main/Labs/Hands-on%20Lab%20-%20Building%20Multi-language%20Reports%20for%20Power%20BI.md)
You have to right click on the slicer column and select "Show values of selected field":
Now it's showing the desired result:
English
German
3 Replies
I figured it out after carefully reading the documentation (https://github.com/PowerBiDevCamp/TranslationsBuilder/blob/main/Labs/Hands-on%20Lab%20-%20Building%20Multi-language%20Reports%20for%20Power%20BI.md)
You have to right click on the slicer column and select "Show values of selected field":
Now it's showing the desired result:
English
German
- SamWiseOwl
Super User
Well done! I will have to have a go myself later, cheers for posting.
- SamWiseOwl
Hi Anonymous
I don't have any experience with working with translated languages.
What I will say is looking at the model it feels like there should be a join from Translated name to you Dim table.
Maybe using the DIMID
