Forum Discussion
Solved
SelectedValue as Slicer for MultiLanguage Reports
Hi,
I'm working on creating a multi language report. Since our initial report has a lot pages, i am trying to build a report where i use a language slicer and dynamically change the values.
However I dont know how to achieve it on slicers. I've tried to create a calculated column:
TranslatedMonth =
VAR SelectedLanguage = SELECTEDVALUE('Language'[LanguageId])
RETURN
SWITCH(
SelectedLanguage,
1, 'Date'[MonthName],
2, 'Date'[MonthName_EN]
)
And I used it as my date slicer. However it just gives 24 (12 months for 2 languages) blank values.
And I used it as my date slicer. However it just gives 24 (12 months for 2 languages) blank values.
Is there a way to achieve this or do i need bridge tables etc? I dont want to change the table structure much, im looking for more of a dynamic solution using measures.
Many thanks in advance!
Hi ceren1997
Calculated columns don't respond to slicer selections. Within the calculated column context, it encounters a blank value since SELECTEDVALUE returns blank by default. It remains unaware if any selection has been made in the slicer.
Try using field parameters to switch between columns using a slicer.
