Forum Discussion
Helper IISlicer for Paginated Report
Hi All
I have a dashboard with a matrix and depending on what org I choose in the slicer, there are a lot of rows which cannot be exported to a PDF. So---I created that visual as a paginated report and then pulled it back into the dashboard.
Now the problem I have is that I cannot get the report to link to the slicers in the dashboard and furthermore cannot get it to filter down to a specific org when using the filters. It's just there with all rows showing. Is it possible to filter down a Paginated report with a slicer or filters pane after pulling it into desktop?
3 Replies
Userpath77As a follow up, I did go to format and set it to auto respond to the slicers and still not working
- sayaliredij
Solution Sage
HI Userpath77 ,
Usually it should work.
1. make sure your paginated report is parameterized and you are providing parameter which is connected to your power bi field
2. also enable cross filtering
Double check the steps from the documentation
https://learn.microsoft.com/en-us/power-bi/visuals/paginated-report-visual
Thanks,
Sayali
- Userpath77
Thanks Sayali. I played with Report Builder and things are better now. I have about 9 values in my Parameter for Organization. The only problem I have now is when I pull the paginated report in from Report Builder only 1 of my values from the Org parameter shows, it immediatley filters to just 1 and does not show all. Do you know how to fix this?
