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,"','") & "')

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Narukkp , Thanks for sharing. Kudos to you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi.
      Even I am trying to create a paginated report and trying to pass url parameters from my power BI report. In my case i have about 6 slicers in my Power BI which needs to be passed to my paginated export. Slicers selection could be more than 1 value based upon user selection criteria.

      I see that you have already implemented this logic. Can you please share with me your sample pbix and rdl.

      Thanks.