How to use 1 slicer to filter data from 4 different date columns

[Powerbinic]

Hi, I am trying to create a date slicer to filter out data from 4 different columns and 4 different dates which are in the same table (Table 1).

Data are joined together in the same row (Columns 1 and 2, 3 and 4, 5 and 6, 7 and 😎

Table 1

Column 1	Column 2	Column 3	Column 4	Column 5	Column 6	Column 7	Column 8
Object AB	1/1/2024
		Object ABC	1/1/2023
						Object ABCD	2/2/2024
				Object ABCDE	2/2/2023

If I click year 2023 on date slicer, it should show Object ABC and Object ABCDE.

How do I create a date table for the date slicer and how do I maintain the relationship between the date columns in the newly created date table and Table 1?

[Anonymous · Accepted solution]

Hi @Powerbinic ，

You might consider converting Table 1 in PowerQuery to the following format:

Then create a Date Table for slicer.

Relationship:

output:

Please check the pbix file.

Best Regards,
Gao
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!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group