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
koorosh
Post Partisan
Post Partisan

Drill through

Hello All,

There are 3 tables. One for total sales, one for details of sales 2020 and one for details of sales 2021.

On page 1 of the report, there are two cards that show sales for 2020 and 2021. How we can arrange when clicking on one card, see details of sales related to that year in a table on page 2?

 

Thanks in advance.

 

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

One way is to set up bookmarks on page 2 to show either 2020 or 2021 sales.

2020.png2021.png

 

Since a card visual will not allow for bookmark navigation, you can create a rectangle shape overlay to trigger the bookmark navigation for each card. 

overlay.gif

 

action.png

Make sure the shape if formatted as the top layer ("Bring to front" under format and "Maintain layer order is active under "General"/"Properties"/"Advanced options")

LO.png

And you will get the following:

Drill.gif

 

Sample PBIX file attached

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

3 REPLIES 3

Unfortunately, the file was deleted. Coud you please send it to my email?

koorosh@parsehtech.com

PaulDBrown
Community Champion
Community Champion

One way is to set up bookmarks on page 2 to show either 2020 or 2021 sales.

2020.png2021.png

 

Since a card visual will not allow for bookmark navigation, you can create a rectangle shape overlay to trigger the bookmark navigation for each card. 

overlay.gif

 

action.png

Make sure the shape if formatted as the top layer ("Bring to front" under format and "Maintain layer order is active under "General"/"Properties"/"Advanced options")

LO.png

And you will get the following:

Drill.gif

 

Sample PBIX file attached

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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.