Drill through

[koorosh]

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.

[Ahmedx]

can be used through drill through

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through?tabs=po...
https://www.youtube.com/watch?v=BbplhqDCWOM&ab_channel=LeilaGharani

Sample PBIX file attached
https://dropmefiles.com/S3AUv

[koorosh]

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

koorosh@parsehtech.com

[PaulDBrown · Accepted solution]

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

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. 

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")

And you will get the following:

Sample PBIX file attached