Slicer on Date column is it possible to use edit boxes

[Julan_cdmx]

Hi guys,
I am newbie at Excel dashboards and I'm creating pretty simple ones. But one of the first thing that I'm facing is the following.
I created a dashboard with some pivot tables, I have a slicer using a date value, the problem is that I have a wide date period (2016-2018) and the person who need the dashboard doesn't like to have to choose from the slider all the days in the period he wants the information. He asked me to simply add a pair of edit boxes to type the "From" and "To" period to consult. What could I do to provide a solution? I am in Exce-2010.

Thank you so much for your help.

 

[Chihiro]

May be use timeline slicer?


If not, then it would likely need VBA for what he want's.

Let me know if timeline is ok, if you need VBA solution.

 

[Julan_cdmx]

Thank you so much for your quick response Chichiro, As I know timeline slicers are available since 2013 and I am at 2010. I saw in videos the great use of timeline slicers but I think I need a pair or EditBoxes "From:" and "To:" and I don't know how to pass this informatin to the multiple tables I have connected with the slicer. I am adding a file in which sheet "Tablero" I have the slicer "Fecha de Salida (Utilización)". As youl see the values range from "2016/10/01" to "2018/09/21" and for the user of this file is very complicated to select the period of interest. She likes the date slicer but she alternately would like the pair of edit boxes and keep the same behavior in all the other elements.

Thanks a lot.

 

[Chihiro]

Ah thought 2010 had timeline for some reason. Right, it's only slicer that was introduced for 2010.

In that case, as I've mentioned. You'd need VBA. Is your client ok with use of VBA?

Edit: Or alternately, PowerQuery add-in. But this requires refresh of data after dates are set.

 

[Julan_cdmx]

Hi, thanks
Do you mean VBScript(The one that can be included in macros in the worksheet)? in such a case the client would be Ok. Maybe PowerQuery add-in but I don't have any idea of what is PowerQuery while I have written VBScripts in my Excel Files.

Best regards.

 

[Julan_cdmx]

Hi, Chichiro,

Yes I think I would need to write some VBA code to be able to use a pair of edit boxes "From" & "To" to specify the period of time I need to specify for my Pivot tables related to the date slicer. . Would you be kind enough to help me with this requirement?

Thank you so much.
Best regards.

 

[Chihiro]

See attached sample.

Do note that since this requires loop through each item in slicer, takes a bit of time to update.

If you can base your Pivot Table off of data model. Then you can use another approach which can be significantly faster.