Filter by an Excel table

[Anonymous]

Hello together,

my question is, what is the easiest and fastest way to filter for an excel file?
In this excel file there are over 150 different products that can change daily. I do not want to adjust these values all the time.
Is there a way to filter by an excel file with one column?

Thanks!

[Anonymous · Accepted solution]

I find the visual "filter by list", that solve my problem.

Thank you!

[amitchandak]

@Anonymous , Not very clear, Import excel in power bi, Merge (inner join)  or Join on the model and use as filter/slicer are a few options to filter data