Forum Discussion

AndyDD_UK's avatar
AndyDD_UK
Helper III
1 year ago

Dynamic URL based on slicer selection

In my Dim Table I have a list of items, each with a URL link to the corresponding Power BI report.   In Power BI report 1 I have a matrix and users click on the URL icon to open up the appropriate ...
Need Help
AndyDD_UK's avatar
AndyDD_UK
Helper III
1 year ago

Thanks, I can't get that to work for my scenario...

 

In report 1 I have a matrix with items and URL links to other reports. 

 

In report 1, if the user clicks on item 1 in the list this will open up report 2.

 

However I want the URL to be modified to take the slicer selections with it when report 2 is opened.

 

For example, if the user selects 2025 from year slicer and Jan from month slicer, can report 2 be then opened also containing 2025 and Jan for slicer (not filter) ?

 

Do you know if this is possible ?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi AndyDD_UK 

     

    If I understand it correctly, you want the slicers in the target report (report 2) to explicitly select the values passed from the source report (report 1) when report 2 is opened, right? To my knowledge, I'm afraid this is not possible currently. 

     

    At the moment, the two options that are closest to the desired outcome are Report URL Filter feature and Cross-report Drillthrough feature. However, both of them act similarly to page-level filters or report-level filters, meaning they affect all visuals on the drillthrough page or on all pages. 

     

    The filters do not automatically apply to slicers in the target report. If you want the slicers to reflect the passed filters, you need to set up the slicers manually. 

     

    You might need to adjust your expected result. Hope this would be helpful. 

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!