Forum Discussion

Narukkp's avatar
Narukkp
Helper V
5 years ago
Solved

URL Parameters expression for Multi selection parameters in report builder

Hi Team,   Below expression is working as expected when parameter having single selection but when parameter selecting multi value it is not working as expected. It is not passing the multi selecti...
Need Help
  • Narukkp's avatar
    Narukkp
    5 years ago

    Hi Team,

    I got the solution. We need to give expression like 

    Dim_Corp_Hier/Cur_Area_Nbr in ('" & Join(Parameters!Area.Value,"','") & "')

  • Narukkp's avatar
    Narukkp
    Helper V
    5 years ago

    Hi 

    amitchandak in above example they are using hard coded values but in my requirement through multi selection parameter values. 

    • Narukkp's avatar
      Narukkp
      Helper V
      5 years ago

      Hi Team,

      Any one having idea about how to pass the parameter selected multivalues from report builder to power bi detail report using url action 

       

      • Narukkp's avatar
        Narukkp
        Helper V
        5 years ago

        Hi Team,

        I got the solution. We need to give expression like 

        Dim_Corp_Hier/Cur_Area_Nbr in ('" & Join(Parameters!Area.Value,"','") & "')