Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have two reports, a source report and a target report
The cross report drillthough is set up to go to a hidden page on the target report. This is done by selecting the 'Cross report' toggle to On for that page only.
There is a second page on the target report, which is not hidden. The Cross report toggle is set to Off for this page.
When I drill through from source report to target report, both the hidden and visible pages on the target report are getting filtered by the drill through
Is this by design?
Solved! Go to Solution.
Hi @ansa_naz ,
Based on my test, this is normal phenomenon. The target report works the same as the target page in one report.
For cross-report drillthrough, Power BI passes the filter context to standard pages in the target report. Power BI doesn't pass filter context for tooltip pages, because tooltip pages are filtered based on the source visual that invokes the tooltip.
Reference: Use cross-report drillthrough.
Here is one similar post: Cross Report Drill Through automatically adding unwanted filters to all pages of target report
Of course, you can psot your idea on Power BI Ideas. It is a place for customers to provide feedback about Power BI.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ansa_naz ,
Based on my test, this is normal phenomenon. The target report works the same as the target page in one report.
For cross-report drillthrough, Power BI passes the filter context to standard pages in the target report. Power BI doesn't pass filter context for tooltip pages, because tooltip pages are filtered based on the source visual that invokes the tooltip.
Reference: Use cross-report drillthrough.
Here is one similar post: Cross Report Drill Through automatically adding unwanted filters to all pages of target report
Of course, you can psot your idea on Power BI Ideas. It is a place for customers to provide feedback about Power BI.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for this, didnt realise every page in the Target report would be filtered. I have upvoted an item on Ideas.powerbi.com to have this changed so it is easier to use:
https://ideas.powerbi.com/ideas/idea/?ideaid=09ae958d-7699-4ebd-bf2b-3ad1541cbe21
Cheers
@ansa_naz , You can remove the filter from Drill through box and check
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
So what I have for the target report is below:
This is the visible page in the report, which should NOT get filtered by the drillthrough - Cross Report toggle is Off:
And I have the below hidden page, which I have set to drillthrough to as the Cross report toggle is On:
When I drillthrough to this target report, both of the above pages are getting filtered from the source report. How is that possible?
Hi @ansa_naz ,
Cross Report option on tabs are used to filter across different Power BI reports.
See below link for more explanation:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through
In your case you have all the tabs in same Power BI Report, so you don't need to Switch on this option.
You just need Drillthrough filters to set-up your actions.
In your 2nd screenshot (1st hidden tab), you have got 4 filters as drillthrough filters and these are coming from 1st un-hidden tab. Therefore this tab is getting filtered.
If you don't want to KEEP ALL FILTERS as drillthrough filters on your hidden tab, uncheck KEEP ALL FILTERS option.
Hope this helps.
Thanks,
Pragati
Hi @Pragati11 I believe there may be a misunderstanding here. The screenshots show only the Target Report. I also have multiple Source reports which I dont believe have any releance to this issue I am having, so didnt show any screenshots for them
When I drillthrough from a Source Report, both pages of the Target Report are getting filtered. I need only the page where Cross Report is toggled On and active to get filtered.
Is this possible?
Hi @ansa_naz ,
A little more detail like screenshots are required on your issue. Ad some screenshots around your query.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Have you moved a filed under DRILLTHROUGH FILTERS on your 2nd page of your Target Report similar to on 1st page?
Thanks,
Pragati
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
86 | |
84 | |
68 | |
49 |
User | Count |
---|---|
138 | |
111 | |
103 | |
64 | |
60 |