How to drillthrough from any graph with a single field

[o59393]

Hi all

I am trying to drillthrough from any graph selection(s) you make on page 1 with a single field I created. For this, I created a table called "drill" with a column named "drillthrough".

My intention would be to have on "page 2" the projects updated based on whatever selections you drilled on "page 1". 

For example if on page 1 you filter the category manufactruing and and WA region, it should only show you the projects related to these selections on page 2.

After creating the table, I asssigned the drillthrough column to page 2 as this:

Then, on page 1 I filled the drillthrough option:

After I make the selections on my graphs, the drillthough button wont work 😕

Any idea how to solve it?

pbix https://1drv.ms/u/s!ApgeWwGTKtFdhyJot7s4-dX2mS-8?e=dvubzE

Thanks!

[jdbuchanan71]

@o59393 

GIve this video a watch.  It talks about what you are trying to do.
https://www.youtube.com/watch?v=LG-fdqSIFxE

[o59393]

Hi @jdbuchanan71 

That's exactly the one I used haha. The problem I have is the part starting on minute 3:50. 

If I add the drillthrough to my graphs it will give me errors.

Plus I have also a slicer that would like to know if it's compatible with the drillthrough when you pick something,

Any advise how to make it work?

Thanks!

[jdbuchanan71 · Accepted solution]

I modified it a bit, added a drillthrough column to your data table with just the value of " " and joined in the drillthrough table.  That seemed to help with the errors and use, because you set the drillthrough to keep all filters it will bring the slicer selections with it.  My updated copy of your file is attached.

[o59393]

Yes !! @jdbuchanan71 

I didn't know those extra steps.

Thanks a mill!