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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Ironpixel
Employee
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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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