Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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.
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.....
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |