Forum Discussion
drop down instead slicer
hi team,
how to set up a drop down for while creating a dashboard using power Pivot, instead of slicer?
and also making sure they interact with each of the charts?
Based on my example:
1. Create a slicer in sperate sheet (Product)
2. Create another Pivot Table and drop only ( Product) in the filter section
3. Under the Slicer Report connection, make sure both pivot are connected to the slicer.________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
9 Replies
vjnvinod
If your question is related to Power Pivot and you need to have a slicer converted to a dropdown, it is not possible. Instead, you can 1. Create a slicer
2. Create another Pivot Table and keep only the field which you in the slicer in the filter
3. Under the Slicer Report connection, make sure both pivot are connected to the slicer.
4. Hide the Slicer________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
