Forum Discussion
Drillthrough question
I went back and retried the solution and got it to work this time.. so not quite sure what I missed last time.
I ended up using the LeadId from my fact table for one and the LeadId from my main lead table for the the other one.
Community SupportHi Anonymous,
Could you please tell me what does the context menu stand for? Also please share your pbix to me so that I can help with that.
Regards,
Frank
The pbix is too large to share.. if you need a sample we can probably put one together next week if these screen shots don't do the trick.
We have two main pages and a log data page.
We have a drillthrough filter on "Class Build Detail", "Class Build Fall Off" and "Log Data"
Accessing drillthrough from main pages we get all other the pages that have the same drillthrough filter. What we want to see is only the Log Data menu option. It would be cool if it would only add "Hidden" pages to the context menu or the pages with a return button on them.
From Classs Build Detail
From Class Build Fall Off
Log Data Page is the only page with a return button on it.
- v-frfei-msft
Hi Anonymous,
Based on my test, we can put both Leadid columns from different tables to the DRILLTHOUGH of Log data page. Then there will be only one option when you use drillthrough in Page Class Build and Class Drop.
For more details, please check the pbix as attached.
https://www.dropbox.com/s/8z9k85j2vobjk1u/Drillthrough%20question.pbix?dl=0
Regards,
Frank
- v-frfei-msft
Hi Anonymous,
Does that make sense, If so, kindly mark my answer as a solution to close the case please.
Regards,
Frank
It looks like the menus can be turned off using your solution.. but log data is only filtered based on the first filter.
The two pages we have are the same date table ... just filtered differently between the two pages. So, I don't see how we could "manufacture" another LeadId to be used as a filter.
I went back and retried the solution and got it to work this time.. so not quite sure what I missed last time.
I ended up using the LeadId from my fact table for one and the LeadId from my main lead table for the the other one.