Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Experts,
I have a summary report and also detailed report for both the report we have same slicers.
The requirement is to have a button which will route from summary report to detail report with the same filter conditions/selections.
I was able to achieve first part by switch functionality but filter condition is getting reset in Detail report.
For example in the screenshot if I select a Fiscal Year and particular sold to in summary report, I need a same selections in detail report as well .
Solved! Go to Solution.
Hi @raja_2310 ,
Please check if the feature "cross-report drillthrough" can achieve your requirement... Before do that, please remeber to enable cross-report drillthrough option first: Go to File > Options and settings > Options, select Allow visuals in this report to use drillthrough targets from other reports under Cross-report drillthrough in Report settings tab.
Use cross-report drillthrough in Power BI
Best Regards
Hi Amit,
Above link was to drill through from one page to another page in same report.
My requirement is to drill through from one report to another report, here the tables are different between the reports but column name is same also when we do drill through filter condition from report 1 should be taken automatically in report 2. IS there any way to achieve this?
Thanks,
Senthil
Hi @raja_2310 ,
Please check if the feature "cross-report drillthrough" can achieve your requirement... Before do that, please remeber to enable cross-report drillthrough option first: Go to File > Options and settings > Options, select Allow visuals in this report to use drillthrough targets from other reports under Cross-report drillthrough in Report settings tab.
Use cross-report drillthrough in Power BI
Best Regards
@raja_2310 , Sync slicer and navigate button or drill through
Looking at what you want drill through seems like a better option
Power BI Drill Through - More than one level: https://www.youtube.com/watch?v=hCAAvpppQmk
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |