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.

     

ceren1997's avatar
ceren1997
Frequent Visitor
1 year ago

Thanks danextian your approach was very beneficial!

 

I've also figured out an additional solution.

 

I've use a field parameter for my date slicer where i have both MonthName and MonthName_EN columns. 

 

I've noticed MonthName takes the id 0 and monthname_EN takes the id 1 and there is no way to alter that.

 

So, i've updated my language table in accordance and managed the relationship between the date field parameter and language table.

 

Now, it works as desired.