Data Slicer - Filter Date Range

[FilippoV]

Hi Community,

i'm looking for a slicer that allow the user to filter a date range, example:

From 01/01/2017 to 09/10/2017 and from 01/01/2016 to 10/10/2016.

I use "Date Hierarchy" but this custom visual does not work very well with bookmarks.

Any suggestion?

Thanks

[miltenburger]

I think this one will fulfill your needs

https://store.office.com/powerbiaddininstallpage.aspx?rs=en-001&assetid=WA104380786

[FilippoV]

Thanks @miltenburger for your quickly response.

I've find Time Slicer but i'm not understand how to select date range not consecutive, example:

2014 from jan to sep vs 2015 from jan to sep.

See down image

[miltenburger]

Np @FilippoV

In this slicer it's not possible to select 2 date ranges (didn't understand that's what you wanted)

Sounds really stupid, but you have te make two slicers as far as my knowledge goes.

So if you need two date ranges make 2 time slicers (it's not a nice method if you need more then 2 ranges, because you need more slicers....)

Hope it helps you?

[FilippoV]

thanks @miltenburger but in my case the user want select over 2 years.

[v-yulgu-msft]

Hi @FilippoV,

Per my knowledge, users are not allowed to select two or more date ranges in a single slicer. I'm afraid your requirement cannot be achieved currently.

If the data ranges selected for each year are all the same, maybe you can create three slicers to display Year, Month and Day separately.

Regards,
Yuliana Gu