How to apply additional filter on a visual

[anmolmalviya05]

Hi Everyone, I have a requirement in which i have to apply filter on name field on a table visual,

Presently I only have 4 names available in the name column, I want to apply filters of 10 names such that if any data comes in future related to them then it will get filter out.

I tried to manually add the name by switching the basic filtering to advance filtering but it's only allowing me to add limited number of names.

Is there any other possible way?

[amitchandak]

@anmolmalviya05 , You can check if the preselected slicer can help. As of now, we can not default value of the slicer using measures

https://appsource.microsoft.com/en-us/product/power-bi-visuals/insiderscoop1611244107840.powerbi_cus...

[anmolmalviya05]

Hi @amitchandak, Thanks for your reply,

I want to apply this using filter option in filter pane.

I have attached a screenshot for reference, 

Here I'm able to add only two values other than the value available in dataset. But i want to add 10 such values. 

Approach I tried: First i selected all tha values available in dataset from basic filtering, then switched to advance filtering and replaced the existing name, but this is possible only for the number of names present in the data, i.e in this case i can only add 4 names, but i want to add upto 10 names.

[v-junyant-msft · Accepted solution]

Hi @anmolmalviya05 ,

Thanks for amitchandak's reply!
And @anmolmalviya05 , you can try this:
Here is my sample data:

You need to add another table with all 10 names in it:

Then use this DAX to create a measure:

Measure = 
IF(
    MAX('Table'[Name]) IN VALUES('#10'[#10]),
    1,
    0
)

Make the settings as shown in the following figure:

And the final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.