Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Ignore parameterized filtering in report URL

Hi,

 

I have the following question:

 

I have a source/overview report from which it is possible to link to a target/detail report in the Service via a dynamic URL string. The URL contains the filters that are being applied in the source report.

 

1. At the moment when linked to the target/detail report the slicers in that report only show values that exist within the filters that are applied in the URL (detail report contains slicers to enable end users to adjust filters in detail report without having to go back to the source report, change filters/parameters and link through a second time). 

Is it possible in the above situation to have the slicers in the target report also show values that are excluded by the filter context? 

2. In the same situation as above, DAX measures are also filtered in the target report by the filter context in the URL. Is it possible to ignore this filtering by using ALL function in the DAX measures? 

Thanks,

 

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • IC_SLFLORES's avatar
    IC_SLFLORES
    Helper II
    3 years ago

    I guess I'm wondering why you didn't utilize a drill thru page rather than a seperate report? You can create a drill thru page that is only "visible" when you drill thru on a button, not on the navigation panel. You can then sync the slicers throughout your entire report or on select pages so they remain "synced" when they navigate to detail page. You can also make use of the filters panel itself, drag the dimension you are looking to filter to "all pages" whcih would also in affect apply a filter context to the entirity of your report.