I want to create a single date slicer that affects two charts that each use a different date column.

[Pintobean80]

So I have a single page with two charts in it. Each chart is using a different date column (one chart is using "candy arrival date" column and the other is using "drink arrival date" column).

I want to create a year slicer and a quarter slicer that will affect both charts at the same time. How do I go about doing that? I've been trying to wrap my head around this and can't figure it out.

[Anonymous]

Hi @Pintobean80 ,

Hope you are doing well.

Please follow these steps:
1. First, two charts containing "candy arrival date" and "drink arrival date" were created.

2. Extracts the union of the year and quarter of the date columns of two tables.

3. Add two calculated columns to the candy table and drink table respectively, representing the year and quarter. This is so that we can better establish the relationship between tables when modeling data.

4. Perform data modeling and establish relationships between tables.

5. Add quarterResult and yearResult to the slicer respectively, and then you can filter based on year and quarter.

I would be grateful if you can reply to me at your earliest convenience.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Pintobean80]

I'm sorry, I should have mentioned that both of these date columns are on the same table. Would that change the approach you mentioned?

[Anonymous]

Hi @Pintobean80 ,

Thank you very much for your prompt reply.

I don’t quite understand something about the two dates you mentioned being listed in the same table. I would be very grateful if you could reply to me when you are free:

Are your two date columns the same date in each row? Or a different date?

If they are the same dates, filter one of the columns to achieve the effect you want.

If the dates in the two columns are different, I think I need to give you an example to explain my doubts:

If in the second row of the table, the candy arrive date is 12/31/2022, and the drink arrive date is 1/12/2021, when 2021 is filtered in the slicer, the candy arrive date will display the data for 2022, but you are The slicer does not filter out 2022, and the logic at this time is not smooth.

I would appreciate it if you could provide a copy of the Power BI Desktop file.

Looking forward to your reply and wishing you all the best.

Warm Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[amitchandak]

@Pintobean80 , You need to create a date table with the required columns And join both dates(without timestamp) with that date table. Suppose they are from different tables. You can now use the Date Table columns in the slicer. If they are in the same table. one join will be inactive and you can use USERELATIONSHIPto enable another join

example

CALCULATE(SUM(Table[Value]),USERELATIONSHIP('Table'[Date],[Date])

examples of USERELATIONSHIP

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

Date Table

https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...
https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5e...
https://amitchandak.medium.com/cheat-sheet-power-query-financial-year-calendar-5ceaacb520f1

[Pintobean80]

Both dates are on the same table. Would that complicate things?