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

Filter dashboard basis two date ranges

Hi everyone,

 

I want to filter my dashboard basis two date ranges, i.e. I want one date range between 08/01/2018 to 08/25/2018 and second date range to be 08/01/2019 to 08/25/2019 to compare certain metrics in these two date ranges. The dashboard should update the corresponding years' merchandise volume and other numbers for both these ranges accordingly. For e.g. output would look like

image.png

If I change the date range to -  between 08/01/2018 to 08/07/2018 and 08/01/2019 to 08/07/2019, it should update the corresponding 2018 and 2019 values (volume, order count etc. ). I'm taking this data from a single table. Any help will be greatly appreciated. Thanks so much !

 

1 ACCEPTED SOLUTION

Accepted Solutions
PANDAmonium Regular Visitor
Regular Visitor

Re: Filter dashboard basis two date ranges

You can do a few things. If you're okay with the date range not crossing between months, you can create a dropdown slicer just for month and a slider (between slicer) just for date.

  • Create a slicer visual.
  • Expand the date heirachy within your date field.
  • Select month and drag it into your slicer.
  • Swith the slicer to dropdown or however you want to display it.
  • Repeat with Day from your date heirachy and switch to a slider.

Or you can create a new column with the dates all set to them same year like 0001 or whatever, and then filter the new column however you normally would filter dates like maybe with a slider or one of the calendars from the marketplace.

View solution in original post

2 REPLIES 2
PANDAmonium Regular Visitor
Regular Visitor

Re: Filter dashboard basis two date ranges

You can do a few things. If you're okay with the date range not crossing between months, you can create a dropdown slicer just for month and a slider (between slicer) just for date.

  • Create a slicer visual.
  • Expand the date heirachy within your date field.
  • Select month and drag it into your slicer.
  • Swith the slicer to dropdown or however you want to display it.
  • Repeat with Day from your date heirachy and switch to a slider.

Or you can create a new column with the dates all set to them same year like 0001 or whatever, and then filter the new column however you normally would filter dates like maybe with a slider or one of the calendars from the marketplace.

View solution in original post

rkaul Frequent Visitor
Frequent Visitor

Re: Filter dashboard basis two date ranges

Hey , thanks a lot for that solution. That solved my problem. Really appreciate it !


@PANDAmonium wrote:

You can do a few things. If you're okay with the date range not crossing between months, you can create a dropdown slicer just for month and a slider (between slicer) just for date.

  • Create a slicer visual.
  • Expand the date heirachy within your date field.
  • Select month and drag it into your slicer.
  • Swith the slicer to dropdown or however you want to display it.
  • Repeat with Day from your date heirachy and switch to a slider.

Or you can create a new column with the dates all set to them same year like 0001 or whatever, and then filter the new column however you normally would filter dates like maybe with a slider or one of the calendars from the marketplace.


 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 148 members 1,726 guests
Please welcome our newest community members: