cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rawanmashaal Visitor
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 REPLY 1
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.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 68 members 1,402 guests
Please welcome our newest community members: