Drillthrough - removing filters or predeterminating the ones to be used

[pbi_apprentice]

Hi,

I have data that refers to events, with my rows being something like this :

[App Name], [date], [Familly of Event], [value]

So at the moment, I've got a visual that allows me to see what are the most frequent family events, and the concerned apps, according to [values], and a slicer to filter by date.

I'd like to do a drill through from there, so I can get more details about the app I see in this visual, but the problem, is that it keeps the [family of Event filter], and thus I am not seeing all information about the app on the previously selected time period.

Here my [Family of Event] is 'Socle' and 'Appli', but I don't want to keep this filter when doing my drillthrough.

My target page is takes 'Application' as extraction field, I've tried adding my [Date] fields and de-activating 'keep all filters', without success ( it would drillthrough the 'Application field')

[v-henryk-mstf]

Hi @pbi_apprentice ,

The premise of drilling requires a corresponding hierarchical structure.You may wish to use the edit interactions function to select the objects that need to be filtered.

Can you provide more information (such as the test data model for deleting sensitive information and screenshots of the expected results) I will answer you as soon as possible.

Best Regards,
Henry

[pbi_apprentice · Accepted solution]

Hi,

Here is a image from my data model :

 

I'm trying to sort my Apps according to 'Values' and sort them in the previous visual by 'Famille applicative'. The desired result is that when i drillthough the visual, i keep all filters except the 'Famille applicative' one, because it's only purpose was organizing the data in the visual.

In the end I worked around my problem by creating an independent table for the category i was filtering on that would be used to filter this visual only, and thus, even if the filter was kept later, it didn't impact my other pages. (I also had to make a custom measure for 'Values' that depended on my new table.

But I hope there is another way to do this.