Overwrite Slicer With Report Filter

[Jarrod]

Hi,

I have a single select dropdown slicer displaying various metrics allowing the end user to view graphs based on this metric. I have selected a default metric, "Team A performance", and published the report.

There is a tool available to generate PDF snapshots of reports. As part of this, I would like to use report filters to generate snapshots of other metrics such as "Team B performance", "Team C performance" etc.

Is there a way to overwrite the slicer with a page level filter and also display the page level filter value within the slicer? EG, when "Team B Performance" is passed in as a page level filter via URL, the slicer should display "Team B Performance" and graphs display data for "Team B Performance". When I do this at the moment, slicer continues to display default value, "Team A Performance", and the graphs display blank. I suspect this is because there are conflicting filters via page level and slicer.

Any ideas?

Edit:My current solution is to publish an additional report not visible to any end users. Instead of a slicer, I have a Card visual displaying the SELECTEDVALUE(Metric). This works however it would be great if I could avoid duplicating reports.

[lbendlin · Accepted solution]

This will only work if it is supported by the data model (ie the URL filter needs to affect a table that either directly or indirectly controls the table that feeds the slicer.  If the slicer continues to have other non-default values then it won't work.