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

Re: Slicer - Date and Time

@Sean PM Sent

Super User
Super User

Re: Slicer - Date and Time

@Stoo48You know I never switched the Slicer in my testing from List to any of the Before, Between and After Options!

 

It seems when you place a TIME column in the Slicer you can only use the List or Dropdown Options

 

I believe the others are only meant to be used with DATES

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/preview/#dateSlice...

 

So there's not really an issue with the Data Type and Format!

 

>>> The issue seems to be with Slicer's  Before, Between and After options not working with TIME Columns! <<<

 

Checkout this blog by @heathernicole @dbadmin

http://community.powerbi.com/t5/Community-Blog/Advanced-Time-Line-Slicer-Sorting-data-by-shifts-up-t...

She discussed the Advanced Time Slicer

 

Good Luck! Smiley Happy

Sorry that's probably not the answer you were we looking for.

You can report this as an ISSUE here

http://community.powerbi.com/t5/Issues/idb-p/Issues

Stoo48 Frequent Visitor
Frequent Visitor

Re: Slicer - Date and Time

@Sean, Many thanks for your input, I'll drop a note to the issues board.

pade Regular Visitor
Regular Visitor

Re: Slicer - Date and Time

@Stoo48This is possible, but not with the on-canvas filters.

Using the Visual Level Filter, page Level Filter and/or Report Level Filters to the right of the canvas you can get this to work. Don't understand though why not implemented directly in the visual filters.

And as the Visual Level Filter are not visable when the report is published, and at the same time as the visual Level Filter is the only filter that accepts a measure, you will need to materialize the date and time combination in a column before beeing able to filter on the date and time combination