Forum Discussion

AndrewDang's avatar
AndrewDang
Helper IV
9 years ago

Set local time zone Power BI Service

Hello all;   I have an issue with setting the right local time for my Power BI Service. I have the same measure to pull the current time. My Power BI desktop file pulls up 1/16/2017 4:36:02 PM whic...
Need Help
wildmight2017's avatar
wildmight2017
Advocate II
8 years ago

I'm going crazy with relative filters. In EST time zone - so I've noticed that as of 8 PM all dashboards with relative filters start working incorrectly. Any good solution for DirectQuery/Relative filter issue? Thank you!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I had to create a create a bunch of duplicate columns for the dates I was trying to report on.  Then adjust for the time diff  Your case this time of year is -4/24.  During winter its -5/24

Reporting Date = Appraisal[CreatedDate] -7/24

Now = NOW() - 7/24

PT Date = DATEDIFF(Appraisal[Now], Appraisal[Reporting Date], DAY)

 

 

 

Then use the last one as a visual filter with advanced filtering and set to show only value of zero.

 

I use the ‘now’ as a unique table as well to then show in the web version the real time its reporting on not the UTC time the programmers think we all work in.  It will be off in your desktop version.