Forum Discussion

Clampazzo's avatar
Clampazzo
Icon for Resolver I rankResolver I
1 year ago

Set TImeZone to user's browser timezone in Embedded

We currently have an apps own data embedded setup of Power BI.  Our Models are currently showing all users date/times based on EST.  However, we would like to modify this so that it will adjust the t...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
1 year ago

Hi Clampazzo 

 

The way I have gone about this for other clients is to create multiple date columns with the daytime offset based on their location. I then have a Sliver in the report page, which will then allow them to select the time zone that they are in and all the corresponding data will then change to that time zone.

Clampazzo's avatar
Clampazzo
Icon for Resolver I rankResolver I
1 year ago

Hi GilbertQ , I'm looking into doing this now.  This could be a solution for my issue.  Do you happen to have an example as to how you did this?  When I attempted to do this I either get a very slow measure or something that doesn't work.  

I did create a table that I named "Timezone Offset" with just 2 columns Timezone and Offset like below

Timezone    Offset

EST                  0
CST                  -1
PST                  -3

I then created this measure to determine which one a user selects if the pull the "Timezone" field into a slicer

SelectedTimezoneOffset = 
VAR SelectedOffset = SELECTEDVALUE('Timezone Offset'[Offset], 0)
RETURN SelectedOffset


I then created this measure in my datetime table to try and allow a user to adjust the timezone on the fly... but this isn't working, visual returned a query exceeded resources error

AdjustedDateTime 2 = 
VAR Offset = [SelectedTimezoneOffset]
RETURN 
    MAX('Create DateTime'[Creation DateTime]) + Offset / 24