Power BI Report Filter Pages

[Zach_Scaturro]

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...

[v-jianpeng-msft · Accepted solution]

Hi, @Zach_Scaturro 

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.

[Zach_Scaturro]

sure! So for every value in the slicer, I would like to have it's own page showing that Values respective data. The values in the slicer however change based off the value in the second slicer (Carbon ID). Does that make sense? 

[Idrissshatila]

@Zach_Scaturro ,

did you check the concept of drill through, check it out https://youtu.be/BbplhqDCWOM?si=XYx7jdqtaY3hVLkJ

[Zach_Scaturro]

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?

[Idrissshatila]

Hello @Zach_Scaturro ,

I didn't really understand what you want, can you show us please?