Help with ambiguous behavior Relative Date in Filter Pane

[rai9micm]

My database contains data that is updated everyday. Client needs two report pages: one with the data of "Today", and another one containing historical series data.

For the "Today" page, I'm filtering the data by the CreationDate variable of the dataset, by using the Relative Date funtion of the filter pane (and checking the "Include Today" option). This variable is only a date variable, it does not include time. This works... until late at night: Around 10PM, the filter seems to understand that "today" has passed and presents "BLANKS" as the output.

Although I might be wrong, this behavior leads me to believe that it is an issue of Timezones. Does the PBI service has a modifable time zone? Btw, this happens both in the PBI service and locally in my computer, as well as on the server where the main PBIX file is deployed to for "production" purposes.

Is there any other recommended way of doing this? I could add another column with a boolean of whether or not such date is today, but it seems unnecesary given Power Bi current capabilities.

Thanks!

[Syndicate_Admin]

You could, for example, add a page filter from the Filters panel with CreationDate, select a filter of type "Relative Date" and set it to show only items that are in the last "1" day, by selecting the "Include today" box.

Another longer solution could be to create specific measures for the page today, including a CALCULATE FILTER of the type CreationDate >= TODAY().

[rai9micm]

Thanks for replying! The first option you described is exactly what I'm doing haha. I really want to keep it that way but I'm facing the issue of it considering "another day" after around 10pm. 

If I can't find a solution here I'll just create a new column in the view that PBI is extracting the data from the database, flagging it as 1 if it's today.

Btw, I'm in the GMT-4 time-zone.