Forum Discussion

Krishna1992's avatar
Krishna1992
Helper I
6 years ago
Solved

Filter based on criteria

Hello everyone,   I have 2 columns in my table, one is category and other is product.   I need to select/filter only required category based on product.   Something like below table, Produc...
Need Help
  • az38's avatar
    az38
    6 years ago

    Krishna1992 

    could you do it manually?

    go to the Power Query Editor pick your table, add Custom column like

    = Text.Combine({[Location], "-", [Category]})

    then filter out all you don't need like in Excel

    do not hesitate to give a kudo to useful posts and mark solutions as solution

adityavighne's avatar
adityavighne
Continued Contributor
6 years ago

Krishna1992 

Add filters or Slicer for Product and Category and give multiple selection option.

 

regards,

aditya

Krishna1992's avatar
Krishna1992
Helper I
6 years ago

Hi adityavighne ,

 

Thanks for your response..Is it possible to filter it from data itself, instead of visuals?