drop down instead slicer

[vjnvinod]

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?

[Fowmy]

@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 🙂

YouTube, LinkedIn

[vjnvinod]

@Fowmy 

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?

[Fowmy]

@vjnvinod 

You can do it using VBA.
Share a sample file to check, 

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn

[vjnvinod]

@Fowmy 

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?

[Fowmy]

@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 🙂

YouTube, LinkedIn

[vjnvinod]

@Fowmy 

this helps

but actually i was looking for drop down something like below

basically List box from the form control

is it possible?

[Fowmy]

@vjnvinod 

The solution I provided works, so kindly accept this as a solution and post this in the forum below as it related to Excel.

https://www.mrexcel.com/board/

Thanks

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn

[vjnvinod]

@Fowmy 

sure

i think it make sense

but can you just let me know how you did that?

Can you give me the steps?

and i close this thread?

[Fowmy · Accepted solution]

@vjnvinod 

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 🙂

YouTube, LinkedIn