cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Two or More date Filters for the same data

I have Data from a View and I want to filter the data with three date ranges. Not necessarily the same date previous year etc. For the same field "Status Date".

Eg: 

Filter1 Date Range: 01-01-2005 to 01-01-2006

Filter2 Date Range: 06-06-2009 to 01-01-2010

Filter3 Date Range: 09-19-20013 to 06-22-2015

 

For the same date field in the view. How do i do it?

1 ACCEPTED SOLUTION
Community Support
Community Support

Hi @Anonymous ,

 

Kindly check the attachment whether help.

dateslicer.PNG

 

Best Regards,

Icey

 

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

View solution in original post

5 REPLIES 5
Community Support
Community Support

Hi @Anonymous ,

 

Kindly check the attachment whether help.

dateslicer.PNG

 

Best Regards,

Icey

 

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

View solution in original post

Community Support
Community Support

Hi @Anonymous ,

 

Please let us know if the post @amitchandak provided is helpful.

 

 

Best Regards,

Icey

Anonymous
Not applicable

Hi,

I did not find @amitchandak  acceptable.

I have a table and three slicers

slicer 1=1/1/2000to9/1/2000
slicer 2=1/1/2002to11/1/2002
slicer 3 =9/1/2003to5/1/2004

 Table:

IdCost Date
12731/1/2000
2413/1/2000
3415/1/2000
4487/1/2000
53869/1/2000
6241########
71581/1/2001
8543/1/2001
93495/1/2001
102037/1/2001
111309/1/2001
12355########
13981/1/2002
143103/1/2002
153625/1/2002
162637/1/2002
171599/1/2002
18194########
192201/1/2003
201403/1/2003
21745/1/2003
22937/1/2003
231449/1/2003
24211########
253961/1/2004
262403/1/2004
272815/1/2004

 

The results should be in the detail report:

IdCost Date
12731/1/2000
2413/1/2000
3415/1/2000
4487/1/2000
53869/1/2000
13981/1/2002
143103/1/2002
153625/1/2002
162637/1/2002
171599/1/2002
1819411/1/2002
231449/1/2003
2421111/1/2003
253961/1/2004
262403/1/2004
272815/1/2004
Anonymous
Not applicable

Any suggestion on how this can be achieved?

Super User IV
Super User IV

@Anonymous , refer if this can help

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors