Forum Discussion
Helper IIDynamic date slicer for 2 date tables?
Hello, I have a table that looks like the below...
I have built a report using data from this table to show me the count of distinct contracts, and the sum of amount. This is controlled by a slicer on the sold date...
Is it possible for me to create another filter to choose either "sold date" or "start date" to filter my report? so for example, if "sold date" is selected on the filter, then the date slicer will filter on the sold date column. And vice versa for the start date one.
Is this doable? I know I could create a copy of the report and just use the start date as a filter but id like to be able to keep everything on one page if possible?
Hi again jd8766
I have checked the link and Page2 it is now working.
Sorry I had wifi refresh problems last night.
Please click the thumbs up and accept as solution buttons. Thank you ! 😀
7 Replies
davehusMemorable Member
Hi @, Quick answer is yes. You could created a disconnected table with Sold Date/Start Date as a slicer option and then use a selected value clause to calculated results using USERELATIONSHIP.
speedrampsSuper User
I will answer this guys and send an example very soon.
I am answering an indentical question. 😀
- speedramps
Hi jd8766
As promissed here is an example.
Please click the thumbs up and accept as solution buttons. Thnak you ! 😀
Click here to download an example
It is the same solution davehus has mentioned 😁
jd8766This is really useful! Thank you for this.
Is it possible to create a filter with one date field... and then another filter to populate this date field with either "start date" or "sold date"
So I would have a drop down with 2 selections. One called StartDate and one called SoldDate
If StartDate is selected, then my date slicer will filter the values on start date only.. and vice versa?