Forum Discussion
Helper IIIRestricting Drillthrough on visuals having same columns as used in drillthrough filter.
I'm running into both of these same problems! Hopefully, there will soon be a good way to do this.
I want to be able to have multiple pages that are the result of drillthrough. However, for any particular visual (and even any particular field within a table/matrix), I want to be able to identify ahead of time which drillthroughs will be available to users.
It would also be great for there to be a way for users to "reset" a particular drillthrough page, if they want to view the data on the drillthrough page directly, and without any drillthrough filters.
You can do so by cloning a column in the power query editor and use that column renamed to distinguish a drillthrough to tab1 or tab2.
Say you have a column named "Process". Clone another one Named "Process1" in the Query Editor.
In drillthrough filters of tab1 use "Process" and in the drillthrough filters of tab2 use "Process1".
Your upstream visuals then can distinguishedly drill down to the desired page / visual.