Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ITInge
Frequent Visitor

How to set timeZone using pbi parameters

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

 

ITInge_0-1611184878425.png

 

Then I create a custom column based on my UTC column

 

ITInge_1-1611185031456.png

I'm stucked here on how can I link the offset number and UTC column to get the right date format in correct timezone ?

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
lbendlin
Super User
Super User

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.