cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ironpixel
Microsoft
Microsoft

Slicer not allowing Date Range

Hello,

I have an older Report where I used a slicer with date to allow me to filter a page based on Date Range

Slicer1-a.png

I am creating a new report where I am trying to do the same thing, yet I keep getting a very different result.

I am not looking for the slider feature.

Ironpixel_0-1602281309071.png

I am trying to figure out how I got to the first version, but can't seem to find the right switch.

I have even tried copying the visual to the new report, and creating from scratch in the same report, but neither has worked.

 

What am I missing?

 

It is also intersting that the options are very different in each one...

 

First version

Slicer1-b.png

Second version.

Slicer2-b.png

 Thank you.

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

click the triangle next to the eraser, Relative Date

 

lbendlin_0-1602290681683.png

 

View solution in original post

I am still on Version: 2.85.985.0 64-bit (September 2020).

 

Don't click the ellipsis, click the down arrow/triangle.

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

click the triangle next to the eraser, Relative Date

 

lbendlin_0-1602290681683.png

 

View solution in original post

Hi @lbendlin 

Unfortuantely I am not seeing that option, although I do remember it from before.

I am on Desktop 2.86.361.0 64-bit (October 2020), and I didn't see it with the on-line version either.

Where are you getting that option?
What version of PBI are you using?

 

I don't see that option when looking at the visual, as that is what it looks like to me with your image.

Desktop:
Relative3.png

On-Line:

Relative4.png

 

The only way to get the dropdown in the filters panel is to have a date checked, yet no dropdown available

Relative1.png

Thanks!

I am still on Version: 2.85.985.0 64-bit (September 2020).

 

Don't click the ellipsis, click the down arrow/triangle.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

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