Forum Discussion

koorosh's avatar
koorosh
Icon for Post Partisan rankPost Partisan
3 years ago
Solved

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...
Need Help
  • PaulDBrown's avatar
    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

     

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
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