Forum Discussion
Filter based on criteria
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
lets start step-by-step.
whats your data source? how it looks like? Table "Lcation-Category" is the only data source? How can we define that for India it should be only watermelon and pinapple?
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi az38 ,
I need to filter category on different location. Which means Every location may have same category or different category.
But I need to select required category for specific location. Ex. if it is India I need to select certain category, if it is US it need to select certain category.
Eg.
India - I need watermelon, apple
US - I need vinegar, watermelon, pinapple.
Likewise I need to multiple location. Only DAX is possible or can I do in query editor. Thanks for your response.
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
how can we understand that for India doesn't need vinegar, for USA - apple? is there a rule or it should be selected by user?
do not hesitate to give a kudo to useful posts and mark solutions as solution
Hi az38 ,
I was not a rule or selected by user, it was my requirement to select only required category. User only requires specific category from each category.
or create a DAX calculated column
=CONCATENATE([Location];[Category])and filter out in the visual
do not hesitate to give a kudo to useful posts and mark solutions as solution