Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
AlejandroF7
Frequent Visitor

Please help with date filters

‎11-16-2022 05:06 PM

Hi guys, I'm using the next filter in a visual where I want to see only the values for today:

So I filtered "the last 1 day including today". But this is not working because it shows Nov/17, and it still is Nov/16 in Mexico, so I think it is an issue with the regional settings, but I don't know how to fix it. Thanks in advance!!

AlejandroF7_0-1668646934816.png 

Labels:
Message 1 of 2
171 Views
0
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

‎11-16-2022 07:46 PM

@AlejandroF7 , if you date has timestamp, it might not be working, use a date not having timestamp

 

a new date = datevalue([datetime])



View solution in original post

Message 2 of 2
122 Views
1 REPLY 1
amitchandak
Super User
Super User

‎11-16-2022 07:46 PM

@AlejandroF7 , if you date has timestamp, it might not be working, use a date not having timestamp

 

a new date = datevalue([datetime])



Message 2 of 2
123 Views

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All