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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

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

August Carousel

Fabric Community Update - August 2024

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