Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
klehar
Helper V
Helper V

Drill Through reset filters

Hi,

 

I have a bar chart of sales by ship mode that drill throughs to another page to enable detailed table

So If i click Ship Mode = Standard then only standard is shown on the drill through page.

 

However what I want is after I go back to my bar chart page, my drill through page should reset its filters to show all values

Can i do that.

If this is not possible directly is there a workaround?

7 REPLIES 7
v-yalanwu-msft
Community Support
Community Support

Hi, @klehar ;

Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft
Community Support
Community Support

Hi, @klehar ;

I'm not quite sure what you mean. Could you give me an example to illustrate?


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft
Community Support
Community Support

Hi, @klehar ;

Method 1:you could clear the filter after drill through.

vyalanwumsft_0-1658913753203.png

Method 2:if you don't want to keep the filter about drill through ,To jump to another interface that is not affected by the first page (show all), use button+ Page (or button+bookmark).
1.add button.

vyalanwumsft_1-1658913876311.png

2.set action.

vyalanwumsft_2-1658913982709.png

the final show:

vyalanwumsft_3-1658914012426.png


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I didn't get the second solution

I want to enable automatic learing of filters when the user navigates back to main page

edhans
Super User
Super User

No, it retains its settings. Pages you drill through to should not be used as normal pages as the drill through function is confusing. I always hide my drill through pages so the user can only get to them via the drill through.

 

You can clear the filters on the drill through page - they are the italics filters in the lower right. But that isn't intuitive for users. You could also place a button at the top that says "clear filters" and connect that to a bookmark on that page that resets filters to your preference.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

@edhans appreciate your quick response

This is what I did so far. Seperate the dirll through page and details page

However my report has exploded and hence I wanted to combine my table view page and drill through page so that they can serve 2 purposes.

That is the price paid when trying to get 1 page to serve 2 purposes. The software isn't designed that way. It assumes 2 pages, and the drill through is hidden only accessable via a drill through action.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.