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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Ibrahim_shaik
Helper V
Helper V

Time Slicer Between Style Shows only Date. NOT TIME

Hi Power BI Community,

 

I have a table with a DateTime Column I have separated the date and time into two columns and I want to filter the line chart separately with date and with time.

 

I have used the Between Slicer for Date I want to use the Same Between Slicer for the Time as well but when i Place the Time column in the value field in the Slicer it only shows Date and I get a weird date 12/30/1899.

 

Another thing is I want to create a disconnected table of Time with 1 hour interval in 12 hour format AM/PM. and then I should be able to filter the line chart with that Time Table. as I have time 15 interval time data, i want to filter the line chart "Between" two different timestamps. I tried creating the disconnected Time Table but I was not able to filter the line chart.

 

I have attached the Screenshots of the Slicer and DateTime Table.Time Slicer Between Style .png

 

Date and Time Table.png

 

Please help.

 

Thanks & Regards,

Ibrahim

0 REPLIES 0

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (27)