cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RMDNA
Solution Sage
Solution Sage

Have drill-through keep one of the selected item filters but clear the others?

Hi all - I'm having a bit of difficulty explaining what I'm looking for, but here we go:

I have a matrix on my main page with a list of unique IDs (P349...), which have a customer ID attached to them (8829...)

 

RMDNA_0-1660933720552.png

 

I want to drill on that specific customer (8829), but not keep the other filters for that entry - I need that customer to be the only filter that gets carried through to the next page. The goal is to pick a line item for a specific customer, then be able to view all historical activity for that customer on the drillthrough page.

Alternately, is there another method to select a value out of a table and use it as a filter on a different page? I haven't really worked with drill-throughs much, and experimentation hasn't gotten me what I need. Thanks!

5 REPLIES 5
lbendlin
Super User
Super User

Two options

 

- on your drillthrough target page utilize measures that remove certain filters from the result

- teach your users how to operate the filter pane, how to distinguish between regular and drillthrough filters, and how to clear filters. 

Hi @lbendlin - I guess I'll need to go the measure route. My users are fairly adept at Power BI, but the whole point was to remove their need to mess around with any filters on their own.

What general approach would you recommend for removing filters within measures?

but the whole point was to remove their need to mess around with any filters on their own.

You may be solving the wrong problem here. Power BI is supposed to empower your citizen data scientists, not constrict them.

 

Within reason of course - asking them to modify measures on the fly might be a bit too much.

I think that's overreaching - I'm looking for this specific drillthrough to be locked down to a single customer ID of their choosing. They have free reign of the rest of the report to do whatever they'd like. I know what Power BI is for.

If you have some suggestions on how to implement the measure filters, I'll take them. Otherwise, I'll mark your initial response as accepted.

What general approach would you recommend for removing filters within measures?

In general you would use REMOVEFILTERS(), but you can also consider using ALLEXCEPT() which is a bit more blunt.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.