How do I create a single slicer from a group of columns
If you cant get a table with one product column before you connect to Power-BI and everything else fails you can to the following:
In the query editor create a new query and refer it to your table above
= YourTableName
So you get the table 3 times. Now for table one delete the columns 4 & 5, for table two delete columns 3 & 5 and for table three delete column 3 & 4. Then rename all columns identical ID, Type, Product.
In the last step you under Home > Append Queries you can append all three tables. Now you got your final table with just one Product column.

I have a data loaded into Power Bi that look like this:




ID
TYPE
Product 1
Product 2
Product 3




1
A
1
1
0


1
B
0
0
1


2
A
0
1
1


2
B
1
0
1


3
A
1
0
0




So every column besides the "ID" and "TYPE" columns, is a binary 0/1 column, that indicates whether certain person acquire given product.
What I want to do, is to create a single dropdown slicer with Product 1, Product 2 and Product 3 values, that will filter only certain persons which acquire selected Product.
