Drill Through - Keep all filters but Ignore Financial Year Slicer Filter

[hadichami]

Hi guys,

I using the Drill through function in PowerBi to jump from one tab into the other and all working fine so far and the filters are taking over into the drilled through page, but for one page I would like my slicer filter which are placed on the dashboard as a slicer visual to not apply. I tried through "Edit Interactions" to disable my time series visual to ignore the financial year filter but somehow the drill through filter overwrite that and still filters on financial year. I have financial year as a slicer on all my tabs and I want to use that slicer so i cant take it out from my drill through filter panel on the right side under visuals. I just want for that specific tab that no financial year filter is applied, but its always overwriting it. I tried to included ALL(..) into my DAX calc but didnt work either. Hope any one has a solution..

[v-dineshya]

Hi @hadichami ,

Thank you for reaching out to the Microsoft Community Forum.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.

Thank you

[v-dineshya]

Hi @hadichami ,

Thank you for reaching out to the Microsoft Community Forum.

Instead of using the automatic “Keep all filters”, switch to a manual approach.

Please follow below steps.

Go to the drillthrough target page (Trendline). In the Visualizations pane, under Drillthrough, turn OFF “Keep all filters”. Add only the fields you want to carry over Drag Productivity Unit Description, CC Level 26, etc. to the Drillthrough field well. Do NOT add Financial Year. Now slicer filters like Financial Year won’t be passed, but others will.

If you drill from Page 2 to Page 3, the filters are applied only from what’s in the drillthrough field. So, if you didn’t pass Productivity Unit Description, it won’t come through.

Solution: You must ensure Productivity Unit Description is also in the drillthrough field list on the Trendline page, even if it was not used for that second drill. Add all relevant fields (Productivity Unit Description, CC Level 26, etc.) to the Drillthrough filter panel of the destination page (Trendline), even if they’re not used in that specific step of the drill.

Fix the issue with DAX.

If you must keep “Keep all filters = On” but want to override a slicer (like Financial Year), use REMOVEFILTERS() in the measure,

Productivity Growth (Ignore FY) =
CALCULATE(
[Your Base Measure],
REMOVEFILTERS('Date'[Financial Year])
)

Note: But this only works for visuals using that custom measure not for slicers or page-level filters.

Please check below things.

1. Turn OFF Keep all filters

2. Manually add all drillthrough fields you care about (except Financial Year)

3. Use REMOVEFILTERS() in DAX if you need visuals that always ignore FY even when slicers are active.

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you

[speedramps]

I want to help you but your description is too vague. Please write it again.

You will get a quicker and better response without misunderstandings if you put time and effort into carefully writing a clear problem description with example input and output data. Look forward to helping you when this information is forthcoming

* Please DON'T copy & paste your DAX that does not work and expect us to fathom what you want. (That is just crazy). ‌‌
* Please DO give a simple non-technical functional description of what you want
* Keep it simple and break large projects into smaller questions and ask just one question per ticket.

* Avoid fragmented problem descriptions that sprawl accross multiple post. Keep it short and simple in one post.
* Rename columns to user friendly names. Avoid your own system jargon that we may not understand.

   for example ,tab, sumary, care group, trendline, cc level and cancer".
* Most importantly please provide example input data as table text (not a screen print) so helpers can import the data to build a solution for you. (Learn how to share data below)
* Provide the example desired output, with a clear step-by-step description of calculations and the process flow.
* Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.
* Remove any unneeded tables, rows or columns which may cause confusion. Keep it short and concise with the minimal information regarding the key problem.
* Remember not to share private data ... we don't want you to get into trouble. ‌‌
* Please click the thumbs up button for these helpful hints and tips. Thank you.

Learn how to attach data in the forum using OneDrive:-
* Save your file in a OneDrive folder
* Right click on the file and click the “Share” blue cloud icon
* Click the bottom “Copy” button
* Click” Anyone with link can edit”
* Click “Can Edit”
* Click “Can View”
* Click “Apply” button
* Click “Copy”
* Paste the generated link via the forum, email, chat, or any other method.
* Helpers can then download your data, build a solution and share it back.

Learn how to attach data in the forum using Dropbox:-
1. Open Dropbox: Access the Dropbox folder on your computer or through the Dropbox web interface.
2. Select File/Folder: Find the file or folder you want to share.
3. Click Share (or Get Link): Look for a "Share" option or a similar "Get Link" option.
4. Choose Permissions: Decide whether to allow "view only" or "view and download" access.
5. Copy and Share: Copy the generated link and share it with anyone via the forum, email, chat, or any other method.

[hadichami]

any idea @speedramps ? Thank in advance!

[speedramps]

Hi @hadichami 

 The drill through page defaults to "keep all filters".

But you can turn off this option and then add which filters you wish.

Please click thumbs up for trying to help.

Then click [accept solution] if it works !

Thank you
Learn more here

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

[hadichami]

This did work, but not perfectly. I got these two drill through filter on my trendline tab. I got 3 tabs: 1. summary, 2. care group, 3. trendline. If I drill through from summary to care group by drilling through under a category from productivity unit description it works. if i then drill through from 2 to 3. trendline by using cc level 26 cancer for example then it only filters on tab 3 on cancer and not giving the filter on producitivy unit description over to tab 3, why?