Filtering by multiple years

[lkarolak]

My table structure is more or less as follows (projects)

Title      Start date       End date

Proj A   01.01.2018      31.12.2018

Proj B   01.01.2018       30.04.2019

Proj C   01.09.2018      31.01.2019

Now I would need to have a filter of the data by year (not the full date). In the above scenario, I need to be able to get "Proj B" and "Proj C" returned if I select either 2018 or 2019 as my filter/slicer.

Thanks for help!

[v-shex-msft · Accepted solution]

HI @lkarolak,

Current power bi filter not works on multiple date column, you need to create a table to store expand detail date form date columns and filter on detail date.

Spread revenue across period based on start and end date, slice and dase this using different dates

Regards,

Xiaoxin Sheng

[Anonymous]

@lkarolak, 

I would suggest you create a Date table here. From then, you can create relationship with your project table, and use the year column in Date table as your slicer.