Two filters in my report - how can I prevent them blocking each other and report results

[julesdude]

Hi there,

I have two drop down filters at the top of my report. Both of them are single select and search enabled. One allows the user to search for a name, the other allows to search for the name ID.

What I'd like to happen is for both of them to work, offering the user the choice of inputing either the ID number OR the name to filter by one specific entity - the report only brings up information of a single entity per selection.

The name filter works fine. It links to a table with a column with all the names available, which itself links to the other tables in the model. 

But the other filter, the ID filter, I can't get to work. It also has a column it filters in the same table the names filter above uses, and I link it to the ID column so that the filter populates with all IDs. I have ensured that in the Edit Interactions, both of these filters aren't filtering the other so they don't influence each other's selections. 

Unfortunately though the moment you select something in the ID filter it drills down further essentially making all linked visuals blank.

What I want is something where if the user makes a selection in one of the filters, it takes presidence and it releases any selection applied by the other filter.

How can this be achieved?

[speedramps]

 Thank you Julesdude

Also try this .... I think is looks more elegant to user who may not understand slicers

Click here to download an example 

In power Query add a column called User 

= [Name]
& " ["
& Text.From([User ID])
& "]"

the user that is a dropdown slicer with search enabled

[speedramps · Accepted solution]

Try this ....

https://1drv.ms/u/s!AgMTUY3Uvq3bg7IZBXZ2dNftYj9Ogg?e=BhnoTq 

Change your user id and user name date type to text, becuse you can't do a text search on a numeric fields.

Add just one (not two)  dropdown slicers to your canvas and add both the Name and User Id

then enable the search option

Well done. You can now search by number or name!

Thanks for reaching out for help.

I put in a lot of effort to help you, now please quickly help me by giving kudos.

Remember we are unpaid volunteers and here to coach you with Power BI and DAX skills and techniques, not do the users job for them. So please click the thumbs up and accept as solution button. 

If you give someone a fish then you only give them one meal, but if you teach them how to fish then they can feed themselves and teach others for a lifetime.  I prefer to teach members on this forum techniques rather give full solutions and do their job. You can then adapt the technique for your solution, learn some DAX skills for next time and soon become a Power BI Super User like me. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volunteer solver will get the kudos they deserve. Thank you ! 

[julesdude]

@speedramps thanks a million. Works good enough for me!