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...

Sample1.pbix27 KB

TotalSales.xlsx9 KB

Sales2020.xlsx9 KB

Need Help

PaulDBrown
3 years ago
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

Sample1.pbix29 KB