Drill through to another report not working correctly When going back to the top level Dashboard

[DebbieE]

I have created two very basic test reports to work with to make this as simple as possible

they both use the same simple table

Report 1, Page 1 Is just filtered on year and has a few visuals. 

It contains column charts with month on the Axis

Page 2 is a basic table

Drill through field is Month and Cross report is switched on On

Report 2 Page 1 is Filtered on Year and Region and has a few visuals including a column chart with Month on the Axis

Both reports are Set File > Options and Settings > Options > Report Settings

Cross Report Drill through - Allow Visuals in this report to use Drill through Targets from other reports

Both reports are published to a workspace.

Once in the Service I create a very simple dashboard from a visual from each report as my starting point

here is where it goes wrong

Start at the Dashboard and go to region. click on the Total from region report Tile

Once in here I right click and get the drill through on the Other report, So far so good. I click this and go to the drill through

Note that the filters are kept as expected from the region report.

Now I decide to go back to the dashboard because I want to go to the main report. 

In this case I click the back button (Because the back button doesnt work on the report when you move between reports)

Or I can simply click on the  Bread crumb trail of POC reports and Dashboards and go back to the dashboard this way

This time I want to go to the main report with just the Date slicer. 

And this is where the problem lies. Notice that the filters from the drill through are still applied so this year report is filtered by Month and region.

When moving back to the start we dont want the drill through filter applying. If you drill through in the same report this works absolutely fine. You can go back and the filters are unapplied. However they arent unapplied when drilling through to other reports.

This means that currently i cant get some of my cruicial logic up and running for users. Please can you advise on this. Its getting pretty urgent. Users have to go in a remove the filters manually every time which is massively increasing complexity

[v-qiuyu-msft]

Hi @DebbieE, 

Is it possible for you to share these pbix file with us? If it is, please remove the sensitive data in the reports, upload them to your OneDrive, post the share link here. 

Best Regards,
Qiuyun Yu 

[DebbieE]

I would happily share the test files but I dont know how to download them here. I cant link to the URL where they are?

[DebbieE]

This is really urgent. Can you advise me what to do to help? 

[v-qiuyu-msft]

Hi @DebbieE, 

If your reports use import mode to get data, you can upload your pbix files to your Onedrive, and paste the share link here. Do remove sensitive data in the file. 

By the way, if your issue is very urgent, I would suggest you create a support ticket to get dedicated support. 

Best Regards,
Qiuyun Yu 

[DebbieE]

Drill down Issue Main report.pbix

Drill Down Issue Region Reports.pbix

Is this what you mean?

Please note that along with the 2 reports using the original documentation you have to publish to a Workspace to see the drill through issue. I added a dashboard with two of the visuals

[v-qiuyu-msft]

Hi @DebbieE, 

The link of shared file is not working. For your issue, I would suggest you create a support ticket to get support quickly as I suggested in my previous post. 

Best Regards,
Qiuyun Yu 

[DebbieE]

Ive added a Support ticket for this. 

[DebbieE]

There is a fix for this issue. For each report if you go into File > Options and Settings > Options > Report settings and make sure Persistent Filters is ticked 'Dont allow end users to save filters'

This solves this problem but brings up another one. What if you want to use drill through AND also allow users to save filters??