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?
thanks Fowmy
i am actually not allowed to share any contents here
is it possible for you to share me a sample of couple of pivot charts connecting to drop downs
and accordingly i can to replicate that codes in my model?
vjnvinod
Please check the attached file. I hope you wanted to filter a chart by a drop-down instead of a slicer.https://1drv.ms/x/s!AmoScH5srsIYgYI-_rdNDaruJbdTXQ?e=a01Ewf
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂