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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Stoo48
Frequent Visitor

Slicer - Date and Time

Struggling with a slicer issue, my data has a date and time stamp in the format "mm/dd/yyyy hh:mm AM" in my query editor, have have split the column to "mm/dd/yyyy" and "hh:mm AM" , so far so good. The data types are defined as "date" and "time"

 

In my report I have applied a date slicer which works perfectly, however my time slicer returns a date format in mm/dd/yyyy as opposed to hh:mm AM, so despite the data being collected and time stamped in the last 72 hours, the time slice is showing 12/30/1899........

 

Any ideas would be gratefully received.

 

Thanks in advance

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@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

View solution in original post

13 REPLIES 13

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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