Forum Discussion
Filter
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.
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.
6 Replies
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
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.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.
