cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
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
Highlighted
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!

Highlighted
Community Support
Community Support

Hi @Anonymous ,

 

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

 

 

Best Regards,

Icey

Highlighted
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
Highlighted
Anonymous
Not applicable

Any suggestion on how this can be achieved?

Highlighted
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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors