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.

     

danextian's avatar
danextian
Icon for Super User rankSuper User
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

    Hi danextian,

    Thank you so much for this brilliant idea! 


    I've never worked with parameters before so im a little confused. Here is my language table:

    And my date table simply has MonthName, MonthName_EN columns in addition to necessary date columns.

    Ive created 2 parameters, one for the languageid and the other is for monthnames, ive added both columns to the parameter. 
    However i couldnt manage to create relationship between those parameters.

    Could you please tell me where i am going wrong?