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

Is there a way to make the table selection sticky?

I have two tables in my Power BI Report. One table is used to filter the other table. Essentially, it is a drive report on consumption by user. 

 

So a user will click their name on a table and the files associated with them below will update. An issue arises when the user will click on something within the second table (i.e to select the path) which deselects the selection from the table above and then its back to showing everyones files again.

 

I have played around with the interaction editor and it cannot be done with that. I also have tried different visuals such as filters, but none of them can act as tables. 

 

Is there any external visual from the store where it can act like a filter (so it can remain sticky) and then that means the second table won't affect any options?

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@dinosainsburys You can teach your users to hold down the Ctrl key when selecting the second table or you could implement slicers.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

@dinosainsburys You can teach your users to hold down the Ctrl key when selecting the second table or you could implement slicers.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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