Basic translation

[libor_slik]

Hi,

I have simple data structrure. There is a sample of my datatable

idmodule;idterm

1;65

1;67

1;143

2;467

2;464

There are another table with text description of module in different language.

idmodule;module_enu;module_deu

1;Base;Basis

2;Health;Gesundheit

I would like to allow user to choose language (English/Deutch). Propably by clicking on slicer based on "language table" or base on some parameters? I dont know. But there has to be the place where language can be choosed and some logic that choose correct column or fill values from correct column into newly created one or something like that.

According to previous choise I want to show datatable with correct "translated" column from second "language table".

Something like that:

1;Base;65

1;Base;67

1;Base;143

2;Health;467

2;Health;464

Or when user choose Deutch, table should look like:

1;Basis;65

1;Basis;67

1;Basis;143

2;Gesundheit;467

2;Gesundheit;464

This is simple sample. I have a lot of other columns for "replacing/translation" - module, submodule, category, environment, term etc. But princip is the same.

This should be functional under the free/pro PowerBI license.

Any help or hint will be greatly appreciated.

Thanks,

Libor

[lbendlin]

You may be interested in this training session. Session 12: Building Multi-language Reports in Power BI · Power BI Dev Camp