Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Bebs
Helper II
Helper II

Use slicer to filter every sheets

Hello,

Is there a way in PowerBI Desktop to use a slicer to modify a global filter (a filter available on every sheets) ?

 

Thanks !

3 REPLIES 3
Bebs
Helper II
Helper II

Thanks both of you.

My plan was to mainly use the filter panel AND to create a sheet dedicated to selections to help people to initialize their selections. 
I tried to use Slicers Synchronization, My concern is : If slicers are not displayed on a sheet, you don't see selections anywhere ? (not even in the filter panel) ?Is that is ?

v-huijiey-msft
Community Support
Community Support

Hi @Bebs ,

 

Thanks for the reply from Syk , please allow me to provide another insight:

 

Open the Sync slicers pane by going to the View tab in the ribbon and checking the "Sync slicers" option.

vhuijieymsft_0-1711594405795.png

 

This will open a pane on the right side of your Power BI Desktop window.

vhuijieymsft_1-1711594357286.png

 

In the Sync slicers pane, you will see a list of all your report pages.

vhuijieymsft_2-1711594357287.png

 

For the slicer you want to sync, check the boxes under the "Sync" column for each page you want the slicer to affect.

 

You can also choose to make the slicer visible on each page by checking the boxes under the "Visible" column.

 

For more details on using slicers, including synchronizing slicers across pages, you can refer to the official documentation here:

Slicers in Power BI - Power BI | Microsoft Learn

 

If you have any further questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Syk
Super User
Super User

You can do this by putting a filter at the report level

Syk_0-1711557841716.png

 

If you really want to use a slicer, go to View > Show Panes > Sync slicers

Select the slicer you want and you can change which pages it filters and/or shows up on

Syk_1-1711557939342.png

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.