Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Paginated Report URL using MultiSelect Power BI Slicer

Hi Community,

 

I am trying to create dynamic URL for paginated report based on my selections in Power BI report(pbix).

 

I have multiselect country slicer and now i want generate dynamic URL for paginated report based on my selections in Power BI Country Slicers.

let's say i have selected India and US in country dropdown.

 

I tried to concatenate my selections using "+" delimiter but still no success. I want the dynamic repetation of parameter and value  pair based on number of multi-select values.

 

My output should be: PaginatedReportURL?rp:country=India&rp:country=US

 

Thanks,

Pravin

multi select parameter
Paginated Report
Paginated URL
  • Hariharan_R's avatar
    Hariharan_R
    5 years ago

    Hi, 

    That post is still covering Power BI Desktop to Paginated Report. You need to create a measure to get all the filter value and frame the URL like below.

     

    Things to do in the PBI reoprt

    1.Create a measure to export 

     

    Excel Export URL =

    VAR __Division =
    IF (
    NOT ( ISFILTERED ( Sites[Division] ) ),
    BLANK (),
    "&rp:Division="
    & CONCATENATEX ( ALLSELECTED ( Sites[Division] ), Sites[Division] , "&rp:Division=" )
    )

    VAR __Site =
    IF (
    NOT ( ISFILTERED ( Sites[Site] ) ),
    BLANK (),
    "&rp:Site="
    & CONCATENATEX ( ALLSELECTED ( Sites[Site] ), Sites[Site], "&rp:Site=" )
    )
     
     

    VAR __FinalURL = CONCATENATE(__baseURL, "&rdl:format=EXCELOPENXML")

    RETURN
    __FinalURL
     
    Thanks
    Hari

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

       

      Actually in above post he was trying to pass parameters from paginated report to Power BI but in my case i want to do it vice versa that is power bi filters to paramters of paginated report.

       

       

      Thanks,

      Pravin

      • Hariharan_R's avatar
        Hariharan_R
        Solution Sage
        5 years ago

        Hi, 

        That post is still covering Power BI Desktop to Paginated Report. You need to create a measure to get all the filter value and frame the URL like below.

         

        Things to do in the PBI reoprt

        1.Create a measure to export 

         

        Excel Export URL =

        VAR __Division =
        IF (
        NOT ( ISFILTERED ( Sites[Division] ) ),
        BLANK (),
        "&rp:Division="
        & CONCATENATEX ( ALLSELECTED ( Sites[Division] ), Sites[Division] , "&rp:Division=" )
        )

        VAR __Site =
        IF (
        NOT ( ISFILTERED ( Sites[Site] ) ),
        BLANK (),
        "&rp:Site="
        & CONCATENATEX ( ALLSELECTED ( Sites[Site] ), Sites[Site], "&rp:Site=" )
        )
         
         

        VAR __FinalURL = CONCATENATE(__baseURL, "&rdl:format=EXCELOPENXML")

        RETURN
        __FinalURL
         
        Thanks
        Hari