Forum Discussion
Slicer and/or Drillthrough Button Help
Hi,
I am a having difficulties creating a drillthrough button where it acts as a page navigation until a graph/table has been selected.
I have a page that has lots and lots of slicers and slicer buttons there is also a graph that shows statuses and a table that shows projects and a couple of other things. I then have 2 hidden pages one called details and one called history. I want a user to be able to use multiple slicers to filter the data, then click the Details or History button and it take you though to that page with the same filters applied, for this I can sync my slicers, make sure they're not visible on the other pages and use a simple page navigation for this, however, if a user selects a status or a project from the table or graph, I need to be able to keep those filters applied, which I can do using a drillthrough on the button.
My issue is that, if I leave it as a drillthrough, the details button won't work unless I select something from the graph or table, and if I leave it as page navigation, it won't filter the status or project. I can't seem to figure out how I could have it conditional so that if there is drillthrough applicable then use page navigation else drillthrough.
Has anyone got any ideas how to do this? Or a better way to go about this altogether?
Many thanks
S
11 Replies
- pankajnamekar25
Super User
Hello Anonymous
for drill through button you can explore this video
https://youtu.be/w5oBmzsjy00?si=o3kvCntydi_RXH_q
Thanks,
PankajIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hi Anonymous ,
Thank you Thejeswar and pankajnamekar25 for the prompt response!
Upon my understanding,Power BI may not allow a single button to switch dynamically between Drillthrough and Page Navigation, but you can achieve this using two buttons with conditional visibility.
1.Create a measure to detect selection using below query:Selected_Status_Project =IF(ISFILTERED('ProjectsData'[Status]) || ISFILTERED('ProjectsData'[Project]),1,0)2.Create two buttons.
Drillthrough Button (Action: Drillthrough) is Visible when Selected_Status_Project = 0.-
Action: Set to Drillthrough to the target page(History).
Page Navigation Button (Action: Page Navigation) is Visible when Selected_Status_Project = 1.
-
Action: Set to Page Navigation to the same target page(Details).
Please refer the attached file for more understanding.
If my response helped you to resolve the query, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
-
- Thejeswar
Hi Anonymous ,
Since you have already synced up the slicers between the pages a simple navigation should work whether you have drill through or not which you have already mentioned.
Now wen you include a drill-through functionality, is it not going to be something in addition to the existing Page navigation functionality.
I am asking in the lines of whether you made both of these implemented at the same time on the tab and try it out.
On the other hand, one thought comes to mind while using the page navigation to pass the contents of the table/graph. Haven't tried this before. So may or may not work.
Have hidden slicers for the contents of the graph / table that you are expecting your users to click for doing a drill through. These filters interactions should be set as filter from the graph / table using edit interaction option. Have the same slicers in the detail and history page (hidden and synced). This way when people click on the value to drill through and use this page navigation technically the filters should pass to the detail page.
Let me know if this solves your question. Would love to know how it works post implementation
Regards,
