change language in Table and Slicer on basis of selected language

[Anonymous]

Hello,

I have folowing data model

With follozong tables

D_COMPANIES

PK_Company	Name	Language
1	Morning Star	en
2	Joie de Nuit	fr

D_SHIFTS

PK_Shift	Code	Decription	Language
1	A	Morning	en
2	B	Midday	en
3	C	Night	en
4	A	Matin	fr
5	B	Midi	fr
6	C	Nuit	fr

F_HOURS_EMPLOYEES

PK_HP	FK_Company	Employee	Date	Hours	Mins	FK_Shift
1	1	Jaden Henderson	01/11/2019	8	25	1
2	1	Jaden Henderson	04/11/2019	8	24	1
3	1	Jaden Henderson	05/11/2019	7	59	1
…
15	1	Alexis Brown	06/11/2019	8	1	2
16	1	Alexis Brown	07/11/2019	7	34	2
17	1	Alexis Brown	08/11/2019	8	25	2
18	1	Alexis Brown	11/11/2019	7	60	2
…
26	1	Londyn Stark	08/11/2019	7	44	3
27	1	Londyn Stark	11/11/2019	7	56	1
28	1	Londyn Stark	12/11/2019	7	56	1
…
39	2	Sandrine Dutoit	14/11/2019	7	53	2
40	2	Sandrine Dutoit	15/11/2019	7	45	2
41	2	Sandrine Dutoit	18/11/2019	7	33	2
…
42	2	Mathias Benett	01/11/2019	7	52	1
43	2	Mathias Benett	04/11/2019	7	37	1
44	2	Mathias Benett	05/11/2019	8	29	1
…
56	2	Émile Jacquinot	05/11/2019	7	54	3
57	2	Émile Jacquinot	06/11/2019	7	54	3
…

D_TRANSLATIONS

TID	TID_DATE	TID_HOURS	TID_...	TID_MINS	TID_SELECT_COMPANY	TID_...	TID_AVG_HOURS	TID_AVG_MINUTES
en	Date	Hours	…	Mins	Select company	…	Avg. hours	Avg. minutes
fr	Date	Heures	…	Mins	Sélectionnez entreprise	…	Moy. heures	Moy. minutes

The following page is made, where selecting a compnay in de slicer, also defines the language

English

French

As one can see, all the titels are translated in the respective languages, but the first column in the tabel isn't, neither is de list for the slicer

No other visuals should be added.

Thanks

RW

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may drag [Code] to Slicer and [Decription] to Card visual.

[Anonymous]

Hi,

thanks for the reaction but this is not a solution.

Moving code to the slicer I get only the codes A, B, C and not the translated descriptions to choose from.

Moreover in the table, the description column is still not translated.

R.W.