Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous
You may drag [Code] to Slicer and [Decription] to Card visual.
@Anonymous
You may drag [Code] to Slicer and [Decription] to Card visual.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |