CODEWITHSUNDEEP
powerbidaxpowerbi-desktop
jonesaphore
jonesaphore

Reputation: 1

Power Bi measures work on desktop application but fail when published

I am trying to create a stacked bar chart of elapsed time. These are the measures I am using:

Start Time = Today() & " " & TIME(07,00,00)

End Time = Today() & " " & TIME(15,30,00)

Time Elapsed = If(((DATEDIFF([Start Time], Now(), MINUTE) / 60)) < 8.5,(DATEDIFF([Start Time], Now(), MINUTE) / 60), 8.5)

Time Left = If((DATEDIFF( Now(), [End Time], MINUTE)/60) > 0, DATEDIFF( Now(), [End Time], MINUTE)/60, 0)

Graphing "Time Elapsed" and "Time Left" works perfectly on the Power Bi desktop application, but when this is published to my online power bi repository, the time elapsed is 8, and the time left is 0. Any insights towards fixing this issue?

Thanks

Upvotes: 0

Views: 247

Answers (1)

mmarie
mmarie

Reputation: 5638

When you work in Power BI Desktop, it will show times and dates (Now() and Today()) in the timezone of the local machine. When you deploy to the Power BI service it uses UTC.

Upvotes: 4

Related Questions