cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tondeli Regular Visitor
Regular Visitor

How to clear drillthrough filter value automaticly?

First... I love this feature. I've been waiting this for a long time and it's finally here!

 

I have created a report that contains drillthrought feature. My report contains several report pages. Here are two cases that are a bit confusing to me. I'd like to know have anyone else faced similar challenges and how you have solved them.

 

1)

As drillthrough function we use a filter and we give value for it from other report page. I click back-button and it will take me back to where I was before. In the background filter value stays unchanged. I use drillthrough function again. Filter value changes and I see visuals filtered with that value. I use back-button again. I navigate to that report page manually and to my surprice value selected in prev step is still selected. I know that I can open my filter selections and clear selected value but I'd like to do is to start exploring my data without any preselected drillthrough filters. Filters in filter pane are a bit confusing to end-users and some of them cannot even find them.

 

My suggestion for this is to add functionality to clear drillthrough filter value when clicking back-button (back-button format).

Ideas - Back-button feature to clear selected drillthrough filter value

 

 

2)

Also if you use same dimension as filter in your report page, you cannot change that either. It only contains the same value as drillthrough filter. You need to clear drillthrough filter value first and start exploring.

 

My suggestion is that we shoud have a feature to use drillthrough filters as filters in report canvas.

Ideas - Use drillthrough filters as filters in report canvas

5 REPLIES 5
v-jiascu-msft Super Contributor
Super Contributor

Re: How to clear drillthrough filter value automaticly?

Hi @tondeli,

 

Thank you for your information. It seems you have answered your questions. I think the drillthrough function acts as a reference for now. You can rename the drillthrough table to "Reference Only" for the moment.

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mshparber Established Member
Established Member

Re: How to clear drillthrough filter value automaticly?

Agree 100%

Clearing filter is difficult to find - needs to be easier.

Voted!

Thanks

iperezlemme Frequent Visitor
Frequent Visitor

Re: How to clear drillthrough filter value automaticly?

Hi Tondeli! 

I'm dealing with this exact same issue, more specifically, with your second bullet. Did you find any workaround to the problem? Still can't believe that Microsoft hasn't done something about this...

I'm using Power BI Embedded and when receveing a filter from my app, the UX is quite awful!!

Regards,

Ignacio

tondeli Regular Visitor
Regular Visitor

Re: How to clear drillthrough filter value automaticly?

I think that you can create workaround using hidden sheets (if those are possible) and bookmarks (homepage to navigate hidden sheets).

 

Still this is too confusing at least to me...

StianHog Frequent Visitor
Frequent Visitor

Re: How to clear drillthrough filter value automaticly?

I'm also missing the function where drillthrough filters can be erased with bookmark.  

Br

Stian

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 393 members 3,417 guests
Please welcome our newest community members: