Forum Discussion
Convert time zones
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
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
3 Replies
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
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.....
The requirements are not clear to me either, but coincidentally yesterday (Central Europe Time :smileywink:) I exchanged thoughts with Chris Webb on a Technet forum that you may find interesting.
