Forum Discussion

ceren1997's avatar
ceren1997
Frequent Visitor
1 year ago
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.   H...
Need Help
Show and Tell
  • danextian's avatar
    danextian
    1 year ago

    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.

     

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
1 year ago

Hi ceren1997 - you can create bridge table if you dont have it as like below. 

Language =
DATATABLE(
"LanguageId", INTEGER,
"LanguageName", STRING,
{
{1, "English"},
{2, "OtherLanguage"}
}
)

 

after that instead of calculated column, create a measure as like below to work dynamically switch the MonthName based on the selected language. This measure can then be used in your slicers or visuals

 

 

attached pbix file FYR.

 

 

Hope this helps. 

 

 

 

ceren1997's avatar
ceren1997
Frequent Visitor
1 year ago

Thank you so much, this would also work perfectly!