Forum Discussion
Drillthrough question
Hi NaCl-y,
If I understand your scenario correctly that you want to Drillthrough from the Clustered column Chart to Gauge, but it doesn't show Drillthrough when you right click on the value of the Clustered column Chart?
By my test, I could drillthrough from Clustered column Chart to the Gauge chart in another page.
If it is convenience, could you share a dummy pbix file which can reproduce your scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
You need to make sure that at least one of the fields from the record you are right-clicking on in the first tab, is in the drillthrough filter area of the second tab. Not just the same/similar field from a different query, it needs to be the same field from the same query.
I am using everything from the same query and my measures are calculated using the elements from the same query,
Looking at the images in your post, I don't see anything that would be passed and act like a filter value. You need something that links the data in the second page to the record you right-click on in the first.
I'm only guessing, but I suspect you are assuming that "Keep all filters" being on is what should make this work, but it doesn't quite work like that.
I thought to link the drillthrough, you had to put in the field the element that you will click in order to go to the drillthrough page. So in my case, i thought of putting "Plan Finish" and "Actual Finish" in the Drillthrough field. It worked for my other graphs, except this one.
To be fair, I have only had a little experience of creating drillthroughs, but as it was earlier today I went back and tried various things to see what would happen. In my case, it only works the way I have described previously.