Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Ironpixel
Microsoft Employee
Microsoft Employee

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

 

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.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors