How to filter more than one column

[pmargari]

Hello,
Would like to know if you have any ideas how to solve this challenge :
I can have, per row, more than one product ( A , B or C) purchased by the customer in the same process.
There will be cases where the customer only purchase A or B or C alone , other that will A and C , etc can have multiple combinations per row, to not duplicate records to have A , B and C in separate per row.
It’s possible to create a filter that will be able to filter product A, B and C ? is this possible as below image ?

Appreciate your ideas comments
Regards
Paulo

[pmargari]

Awesome v-kkf-msft 
thanks a lot for your time and this great help and all the details , really appreciated !
KR
paulo 

[PaulDBrown]

What does the data table actually look like? My first suggestion would probably be to unpivot the product tables.

[pmargari]

Hi Paul,
Thanks for your reply and suggestion 
Here you have an example of the data :

KR
Paulo

[v-kkf-msft · Accepted solution]

Hi @pmargari ,

Please try to unpivot the columns.
1. Select ProdutoA, ProdutoB and ProdutoC columns in the Power Query Editor, and then click "Unpivot Columns".

2. Add a custom column.

= if [Attribute] = "ProdutoA" then [Amount A] else if [Attribute] = "ProdutoB" then [Amount B] else [Amount C]

3. Remove these columns.

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.