Forum Discussion
How to create two level drill-through (or filter slicer based on map selection)
Hi,
I have report to monitor status of retailers from different countries. In the first page we have a map of all available countries and overall status:
From here we can drill through to Country Details page:
From here we can drill through to Retailer Details page... but it doesn't keep the country filter. Because of that if we have more than 1 Retailer named exactly the same in the database the results on the second drill-through page will not look at country we've previously chose, but total for this Retailer:
Do you have an idea how to keep this choice of Country for both drill-throughs?
I've tried different approaches with no luck, e.g.
- SELECTEDVALUE() -> it is deselected after drill-through
- Syncing Slicers -> I've tried to create a slicer that would be kept through both drill-throughs, with a filter measure based on country selected in map, but it didn't work as well:
All suggestions will be welcomed!
Best regards,
Adrianna
2 Replies
- amitchandak
Super User
Anonymous , the First page is passing to the country to second then second can pass to third as long as country id added to -> Add drill through the filter of pages 2 and 3
Hi amitchandak
I've tried that as well, but
1. I don't want to see this RetailerDetails as an drill through option on the 1st page:
2. Even with this setup it is still not keeping it:
