Using 2 Date Slicers for same graph

[Astro1990]

Hi,

I am trying to replicate 2 histograms under same graph, that can be controlled by 2 date slicers. Simply to see a before and after, while keeping all the data.

First I copied the current data that I have into a new table.

Date	Age Freq	Age Bin	Legend
17/10/2022	1840	53,2	1
17/10/2022	1235	56,4	1

In the 2 tables that I now have, I only added legends and changed the date on one of the tables

Date(2)	Age Freq	Age Bin	Legend
17/10/2022	1840	53,2	2
17/10/2022	1235	56,4	2

Then appended the 2 tables to look something like this

Date	Date(2)	Age Freq	Age Bin	Legend
17/10/2022		1840	53,2	1
17/10/2022		1235	56,4	1
	17/10/2022	1840	53,2	2
	17/10/2022	1235	56,4	2

The graph looks like what I want, but the slicers are not really working when I am moving the earliest date. 
Am I way overthinking this? Any help would be greatly appreciated 🙂

[v-henryk-mstf · Accepted solution]

Hi @Astro1990 ,

The two tables are still merged in the same way as above, but the distinction between the data in the two tables depends on the legend field rather than the date field. So creating a dummy table with a legend field as a slicer might achieve what you need.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Astro1990]

Hi, I really appreciate the answers, but I do need 2 different slicers controlling the graph.  



I tried attaching what I am trying to replicate. Date Slicer (Yellow) need to controll full data under the legend without interfering with the (Green graph). 

So that's why I thought just appending the 2 data sets and giving them different dates in the columns. 

Is this even possible? Thank you so much in advance!

[Ashish_Mathur]

Hi,

Rename Date(2) to Date and then append.

[Shaurya]

Hi @Astro1990,

I don't think there is a need to to create two columns for date. Just append the rows from table 2 below table 1. Since they have similar structure, the operation can be easily done and you'll be able to use the slicer.

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts