Filter a table with dropdown

[Anonymous]

Hello again,

I have a table with the following structure:

| Date | description_type | department_description | class_type | quatity_sold | price

I need to create a filter with these options:
description_type
department_description
class_type

And another with these options:
quatity_sold
  price

how can I do it?

[v-piga-msft · Accepted solution]

Hi @Anonymous,

Do you want to create a dropdown slicer with the option below?

• description_type
• department_description
• class_type

If it is, you could unpivot your columns description_type,department_description and class_type in Query Editor, then you could create the slicer like below.

Best Regards,

Cherry