Creating a Slicer that displays the results in a separate page

[rawanmashaal]

Hi All.

So i have an excel file that contains a table of information (title,Domain,...).What i would like to do is create a mulitselect slicer for the titles and each time i choose an option from this list i want to display the information associated with it in a seperate page.( for each option selected i want a seperate page)

I have created a sync slicer but the problem is that if i choose more than one title all information related to those options are displayed in one page.

At the end i would like to export the reults to a power point file so i dont want a page with empty valuse.

Is there a way to do that in power bi?

[edhans · Accepted solution]

Power BI won't create a new page for each selection. You could see a selection in a Drill Through Report, but that is a one at a time deal.

Excel won't do this exactly, but you can create results for each possible outcome on a separate page.

1. Put the field you want to cause your separate tabs on in the filter section of the Excel pivot table
2. go to the "Pivot Table Analyze" tab of the ribbon (Office 365, earlier versions might just say Pivot Table).
3. Select the dropdown in Options on the far left of that ribbon
4. Select "SHow Report Filter Pages."

Note: You cannot do this if you loaded your data to the Excel Data Model. That isn't supported unfortunately. You have to use the classic Pivot Tables for that, so uncheck the "Load to data model" when creating the pivot table.