Big table with multiple fields

[Anonymous]

Hi

I have a big table (about 8 millions records), and this table has 10 fiels that indicate if a customer has or not a specific product. This is an Example:

Table1:

HasProductA | HasProductB | HasProductC  | HasProductD | HasProductE...

         yes        |      no            |       no             |        yes          |         no...

I would like to have a Slicer with all the products, so users are able to select one or more products. Currently, I have multiple slicers that looks awful.

I think that that will be possible only if I have all this fields combined into one... but How should I do that?

Thanks

Thanks

[Nathaniel_C]

Hi @Anonymous , 

Do you also have a products table? We will need to see more. If you do, are the customers and products table related?

Thanks,

Nathaniel

[Anonymous]

Hi Nathaniel

No, I don't have a product table. I have a big table that is denormalized, i.e Products are in the same table that customers.

Should I try to normalize it? Or it may be dangerous?

Thanks

[Nathaniel_C]

@Anonymous ,

Lets reach out to @ImkeF . She is a wiz!

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[ImkeF · Accepted solution]

If you want to have this in once slicer, the relevant column names must become values in a column.

To achieve this you must unpivot them. 

Then delete the rows with  "no" .