Forum Discussion
Power BI Report Filter Pages
Hello,
Does anyone know of a way in PowerBI to show report filter pages like in excel?
I'm trying to show the same page (report) for each value in my slicer. However this slicer can have different values everytime...
Hi, Anonymous
I'm happy to answer your questions. Based on your description, we can use Bookmark to generate separate pages. We can capture the current state of the report page. Bookmarks save current filters and slicers, cross-highlighted visuals, sort order, and more.
For example, I saved the report effect under slicer b through bookmarks, and selected the report effect under slicer b&c at the same time. If I modify the report or slicer under the b page Bookmark, it will not affect the report under the b c page Bookmarks. You can learn more about Bookmark through the link below:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks?tabs=powerbi-desktop
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hello Anonymous ,
I didn't really understand what you want, can you show us please?
Anonymous ,
did you check the concept of drill through, check it out https://youtu.be/BbplhqDCWOM?si=XYx7jdqtaY3hVLkJ
The concept is nice, but I don't think this would work in my situation. If I have a grower who has 5 fields, I want to see 5 seperate pages for export. I could then have a grower with 9 different fields, I would like to see 9 different pages for export. The field list is different everytime for the respective grower.
Show report filter pages in excel is the perfect solution, however I want to use BI.
Is there a solution in power automate?
Hi, Anonymous
I'm happy to answer your questions. Based on your description, we can use Bookmark to generate separate pages. We can capture the current state of the report page. Bookmarks save current filters and slicers, cross-highlighted visuals, sort order, and more.
For example, I saved the report effect under slicer b through bookmarks, and selected the report effect under slicer b&c at the same time. If I modify the report or slicer under the b page Bookmark, it will not affect the report under the b c page Bookmarks. You can learn more about Bookmark through the link below:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks?tabs=powerbi-desktop
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
