Forum Discussion
Filter a table with dropdown
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?
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
1 Reply
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