cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rawanmashaal Frequent Visitor
Frequent Visitor

Creating a Slicer that displays the results in a separate page

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
edhans Super Contributor
Super Contributor

Re: Creating a Slicer that displays the results in a separate page

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.

View solution in original post

1 REPLY 1
Highlighted
edhans Super Contributor
Super Contributor

Re: Creating a Slicer that displays the results in a separate page

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.

View solution in original post

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,838)