Relative Date Slicer using This Day option only filters for UTC

[csaethre19]

I have a report that I need to only filter for the current day. I need the data to be displayed for the entire day, Mountain Time. I have added a relative date slicer and used the 'This Day' option which would work great. However, once the new UTC day starts (6:00pm Mountain Time) the filter shifts to the next day and all my data on the report goes blank. So, if there is someone that wants to view this data after 6:00pm and if there is new data reported at or after this time, no one will be able to view it.

I have been looking for a time zone regional setting in the Power BI desktop application and the Power BI Pro services online for the workspace that the report is published to, and I can't find anything.

How do I get around this?

[csaethre19]

I have added a calculated column with this DAX expression: 

Today = IF('Table'[Date] >= TODAY() && 'Table'[Date] < TODAY() + 1, 'Table'[Date], BLANK())

I added this column to a slicer but it doesn't look like it is filtering the page for today's date. 

[csaethre19]

It appears that I cannot use calculated columns or measures to add to a slicer to filter a page, so I am not sure what the solution here is.

[amitchandak]

@csaethre19 , refer if these two can help

https://community.fabric.microsoft.com/t5/Service/Incorrect-Time-Zone-setting-at-Power-BI-Service/td...

https://www.thepoweruser.com/2019/10/21/handling-different-time-zones-in-power-bi-power-query/

[csaethre19]

I do not have a problem with my dates showing up in local time because at the SQL level I am bringing the data in with the right time zone. The issue lies in the relative date time slicer options. When I add a slicer and have it filter for This Day, it works only in UTC, so when the new UTC day begins at 6:00pm my time the date slicer shifts to the next day and I lose data because I don't have any dates coming into the report in UTC. This is built into Power BI and I am wondering why I can't make it recognize that it should work based on local time and not UTC.