Forum Discussion
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.
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
3 Replies
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
can be used through drill through
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through?tabs=powerbi-desktop
https://www.youtube.com/watch?v=BbplhqDCWOM&ab_channel=LeilaGharani
Sample PBIX file attached
https://dropmefiles.com/S3AUvUnfortunately, the file was deleted. Coud you please send it to my email?
