Filter

[Anonymous]

Hello,

I have a table like that.

And i want to know if it's possible to filter like the filter in excel (look at at screenshot)

And not using a slicer in Power BI, i want to filter it in the table itself.

[v-kkf-msft]

Hi @Anonymous ,

Please try filtering in Power Query Editor or select "Basic filtering" in the filter pane.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hello, Thanks for the answer. i already know that we can do that but that doesn't seem practical since you have to open that panel every time to select the values you want.

But i find a 'trick' to do it like i wanted.

I used a dropdown list from a slicer and put it under the column from the specific table.

Thanks anyway.

[VahidDM]

Hi @Anonymous 

You can add thatcolumn to the table and click on the items, that will filter the report.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[Anonymous]

Hello, thanks for the answer but that doesn't match my need.

Thanks though

[amitchandak]

@Anonymous , No table does not allow filter like that.

Check if this workaround can help

Text Filter Slicer and how to search on Multiple columns: https://youtu.be/RbeZRJ3uAZE

[Anonymous]

Hello, thanks for the answer but that doesn't match my need.

Thanks though.