Convert time zones

[B_Caron]

Good Afternoon,

Our company's managers support four different time zones seperately.

I have been attempting to find a more efficient solution to converting time zones in a matrix table.

My initial thoughts:

-Develop a slicer to change the timezone in the table or replace the column with another column (not possible since the table initiliazes with the report/dashboard)

-Develop a slicer to change the report page after creating a seperate page for each time zone (found no solutions)

-Develop a custom column using a datetime function to get local time to develop a formula to change timezone to local time zone (no local timezone function)

Working Solutions

-Seperate page for each time zone

-Create a seperate column in the matrix table for each time zone

In any case, I was curious if anyone has a better solution.

Many Thanks,

BC

[v-caliao-msft · Accepted solution]

Hi @B_Caron,

Do you have multiple columns which show the time for different timezone, right?

I have test it on my local environment, here is the sample steps for you reference. Sample data.

Create a new table like below.

Create a measure in original table.
selectedValue =
IF (
    ISFILTERED ( Table3[Country]) && HASONEVALUE (Table3[Country] ),
     if(LASTNONBLANK (Table3[Country], 0 )="Chinese",
   MAX(Table2[Chinese]),
   if(LASTNONBLANK (Table3[Country], 0 )="UK",
    MAX(Table2[UK]),
    MAX(Table2[US])
   )
  ),
     BLANK()
)

Then use this measure in your visual.

Regards,

Charlie Liao

[MarcelBeug]

The requirements are not clear to me either, but coincidentally yesterday (Central Europe Time ) I exchanged thoughts with Chris Webb on a Technet forum that you may find interesting.

[CahabaData]

here's a wishy washy developer answer: it depends

how's the data stored? - that's fundamental; is it a universal  time stamp common to all or is the time field data in the local zone time?

and then what are you trying to achieve in terms of a visual....

a sample of a few data rows and a rough display work up of your visual goal would help the forum give a suggestion on how to implement.....