Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter by an Excel table

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's avatar
    Anonymous
    4 years ago

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

     

    Thank you!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

     

    Thank you!

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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