Forum Discussion
Solved
How to Translate Field Parameter Values
A "Stacked Column Chart" needs to display data in Days, Weeks and Months on its X-Axis. To accomplish this I created a Field Parameter via "Modeling > New Parameter > Fields". Here's the generated ...
One solution is to add a fourth column to the field parameter and rename it "Language". Here it contains "en" and "fr". The first column contains the displayed text so we translated those values:
Production Duration X Axis = {("Month", NAMEOF('Production'[YearMonth]), 0, "en"),("Week", NAMEOF('Production'[YearWeek]), 1, "en"),("Day", NAMEOF('Production'[DayDate]), 2, "en"),("Mois", NAMEOF('Production'[YearMonth]), 0, "fr"),("Semaine", NAMEOF('Production'[YearWeek]), 1, "fr"),("Jour", NAMEOF('Production'[DayDate]), 2, "fr")}In our PowerBI reports we have a Translations table with the columns: Language, Description. Go into the Model view and establish a relationship between this Slicer's Language column and the language column from your Languages table.We have a Slicer on the Languages table so when we select a Language it filters the Production Duration X Axis slicer such that it only displays the english or the french labels.
Did you ever find a solution? I'm hitting the same wall.