Forum Discussion
Help with Drill Down or Drillthrough Functionality
In my experience, drillthrough is probably going to be your best bet, where you have it "linked" to a different page that contains the details (others may know differently). PowerBI adds an arrow at the top left of the destination page to send the user "back" to the original page.
On the destination page you put the key value under the "Drillthrough" section under Filters. In your case you might have to calculate a composite key (project-building) to use as the key value. If you are modelled correctly the drillthrough filter should work the same way as an explicit filter on the detail page.
However, note that you may need as many detail pages as you have "drillable" columns (5 in your case?) unless you can rig up measures and slicers that switch between the various spend types.
I know this likely wasn't what you wanted to hear, but hope it helps. Others may have different creative solutions.
David
Community ChampionEverything sounds correct so far, so here's a couple of things to check:
First, make sure you have a relatively up-to-date version of PowerBI. Always best to be on one of the latest 2 or 3 versions.
Second, make sure that the field you put in the Drillthrough Filter box is from the *parent* not the child table (I'd wager it's going to be this one).
If that still doesn't work, see what happens when you make the filter "bi-directional" between the child and parent tables in the model.
Finally if it's still failing, is there any way you can share the PBIX with cleansed data? Any of the common file sharing sites are generally used by people to share their files.
Hope this helps
David
You were right. It ended up being the drillthrough I was using was the one from the child, not the parent.
I truly appreciate your help.