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
