cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lkarolak Frequent Visitor
Frequent Visitor

Filtering by multiple years

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Filtering by multiple years

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

2 REPLIES 2
NickNg278 Senior Member
Senior Member

Re: Filtering by multiple years

@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.

Community Support Team
Community Support Team

Re: Filtering by multiple years

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,911)