Forum Discussion

Zakalwe's avatar
Zakalwe
New Member
9 years ago

Trouble with relative date ranges

Hi there,   I'm new to all this and only have the Power BI free version at the moment. I have a simple Excel spreadsheet in SharePoint Online, had no trouble importing it and creating 3 graphs fro...
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Zakalwe,

The time zone in the service is effectively always set to UTC. On Power BI Service, the now() function will return the UTC time. We can't set the time zone on Power BI Service. To get the correct local time, you can add time different in your DAX formula, or use Power Query to get the local time zone datetime. 

There is a workaround to display time in your current time zone. You can use following power query in the Query Editor if your time zone is 8 hours ahead of UTC.

DateTimeZone.SwitchZone( DateTimeZone.FixedLocalNow(), +8 )

More details, please review this knowledge base and article.

Best Regards,
Angelia

Zakalwe's avatar
Zakalwe
New Member
9 years ago

Hi Angelina,

 

Thanks for the reply. As I mentioned I am a beginner with Power Bi so I have no idea what a "DAX" is or what the Query Editor is.

I just created a couple of simple graphs in the Power Bi website with the basic drag and drop tools there.

 

I'll have a look at those articles and see if I can figure all of that out.

 

Thanks

Scott

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Zakalwe,

    Got it, please don't hesitate to ask if you want clear something up. I think the article describe the solution step by step.

    Best Regards,
    Angelia