Forum Discussion
Helper IVExport to PowerPoint or PDF is not filtered properly
Helper IVI'm using Current Values, but it's exporting as if i have no filtered applied.
I use the filters pane on the right side to filter my report (it is a filter that applies to all 6 pages of the report), but when I export and use (current values), it still exports as if I had no filtering applied, even though it should.
Helper IVI found something interesting. If I have a filter applied via the URL query string (by adding ?filter= to the URL when navigating to the report in my browser), the export does not filter (even though the filter pane does show the filter applied and report works normally otherwise).
I really enjoy the URL filter, it helps me make this more seamless from users navigating to the report from other systems so they land on an already-filtered report view.
v-lionel-msftCommunity Support
Hi CmdrKeene ,
Like this? Your idea is very creative.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- CmdrKeene
That's exactly right. Here's an actual example:
The %2F is a /
The %20 is a space character
The %27 is apostrophe (single quote mark) '
So the same URL can be written as:
Going to the URL does indeed filter the report correctly and all the visuals have that filter applied. But when I export out the PDF, the filter is not applied to the export.
- v-lionel-msft
Hi CmdrKeene ,
This is true, so you need to manually change the filter selection in the filter pane on the right when you export to PDF. Because you will find that the URL link don't change when you change the filter selection.
Or submit an idea .
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.