Forum Discussion
drop down instead slicer
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 🙂
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 🙂
thank you
but unfortunately it doesn't helps my client is little adamant to not use slicer for pivot charts
is there a way i can create a drop down and connect my pivot charts using some excel macros?
