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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Aleksandra_MLT
Advocate I
Advocate I

Drill through leaving slicer only 1 category

Hi guys, I wonder if there is a possibilty to drill through to a different page and leave slicer with all the values and not only the selected one ? So for example now when I am drilling on "Action" I get the only action in the slicer selected:

Aleksandra_MLT_2-1644313307345.png

 

How I want it to be upon I drill through is that the required option is selected but other options are also available?

Aleksandra_MLT_1-1644313144151.png

 

3 REPLIES 3
v-jingzhang
Community Support
Community Support

Hi @Aleksandra_MLT 

 

I recommend Amit's idea. A combination of Sync slicer and Page navigation is a good solution. Here are documentations for your reference.

Slicers in Power BI - Power BI | Microsoft Docs

Create page and bookmark navigators - Power BI | Microsoft Docs

 

There is another method to set dynamic page navigation with a slicer and button in the following documentation. 

Create buttons in Power BI reports - Power BI | Microsoft Docs

 

Hope they are helpful.

 

Best Regards,
Community Support Team _ Jing

amitchandak
Super User
Super User

@Aleksandra_MLT , drill through pass filter and restrict the data on page. So I doubt you can get that option.

 

You can get this with Sync slicer and page navigation, but that do not pass drill value

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Thank you, @amitchandak 

 

could you please elaborate ? I mean if I drill on the table and in the page which I am drilling from there is no slicers... I get I can put it and hide it so it would sync with the ones in the page I am drilling to but main purpose so user can click on the table. I checked - table does not filter slicer. Unless this is not what you meant ?

Helpful resources

Announcements
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!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.