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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Bookmarks with synchronized filters

Hello,

 

I have the following Situation:

 

image1.png

 

As you can see i got a matrix and a table. they are both already filtered. Both are quite big and cannot fit next to each other on one report (but thats exactly what i would like to do).

What i tried is to use bookmarks and a button to switch between them which worked quite good. So i overlayed the two tables, created 2 bookmarks, one showing just the matrix, the other showing just the table. i am then able to switch between them via button.

What i now need is them to save the filters i set. I give you an example for understanding:

 

i filter via matrix down to the data i want to see:

 

image2.png

 

As you can see i select the 1 hour that Dennis (me) worked for a certain customer on a certain project ("Konzeption Sharepoint").

So niw i want to switch to the table keeping the filters to see what the employee commented on what he did during that hour like this:

 

image3.png

So as you can see there are 2 comments on the selected data from the matrix.

As i said if i use the bookmarks and switch between them, the filters reset. Is there a possibility to keep the filters or can you recommend me another way to achieve what i want to do?

 

Regards,

Dennis

1 ACCEPTED SOLUTION

No, but I can send you a link 🙂

 

https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough

 


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

You might want to consider using Drillthrough filtering instead of Bookmarks. They were designed for exactly this purpose. 


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Could you explain this in more detail please?

No, but I can send you a link 🙂

 

https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough

 


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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