Filter Stops Working After Uploading to Power BI Service

[Lali2023]

Hello,

On Power BI Desktop, I have a filter that will only show items due today. This is the formula I use in the created column to single out today:

This_Day = IF('Combined Tables'[Due Date] = TODAY(),1,0)

In the table that is supposed to do the filter, it works fine, showing what is due.

However, when I uploaded the file and the semantic model to Power BI, instead of listing today's item as '1,' it changed it to '0.' I had tried to change the semantic model to say '1,' but the report does not function as it did in the Desktop version.

Does anyone have an idea what I'm doing wrong?

 

[Matt Allington]

when using Power VI desktop, the semantic model uses your local PC time to determine what is today. When you upload to the service, it uses UTC to deferment what is today. To solve this, you can add a certain number of hours or subtract a certain number of hours in order to get your local time zone, eg
=Today() +time(10,0,0)

 

[Lali2023]

Hi Matt,
Thank you for responding. I adjusted the formula to this:

This_Day = IF('Combined Tables'[Due Date] = TODAY(),1,0)+time(10,0,0)

and it gave a result of 12/30/1899 10:00 AM. Do I need to use DAX to do the IF statement and then change the time?