Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I would like to create a report that has dynamique date gestion.
My need it to pass the timezone offset via a parameter. then generate a new date column based on UTC column + Timezone offset parameter.
I started by creating a parameter that have type any ( may be I should change the type ) that should contain the offset for example 3 or -5
Then I create a custom column based on my UTC column
I'm stucked here on how can I link the offset number and UTC column to get the right date format in correct timezone ?
Solved! Go to Solution.
Hi @ITInge,
I think you can add a user table that includes the user and date timezone offsets, then you can add a new column to your date table to calculate correspond datetime based on current date time fields and user timezone offset.
If you do not have these timezone offsets, you can also use the query parameter and 'datetime.addzone' function to change datetime based on timezone parameters..
DateTime.AddZone
Regards,
Xiaoxin Sheng
Hi @ITInge,
I think you can add a user table that includes the user and date timezone offsets, then you can add a new column to your date table to calculate correspond datetime based on current date time fields and user timezone offset.
If you do not have these timezone offsets, you can also use the query parameter and 'datetime.addzone' function to change datetime based on timezone parameters..
DateTime.AddZone
Regards,
Xiaoxin Sheng
date formats and time zones have nothing to do with each other.
Can't you leave the format rendering up to the users' locale settings?
Ok what I mean here by date format is the right time for the user .
How can I be sure that the user will see the dates in his local time zone ?
For information user will only have access to embedded dashboard
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.