How to handle relative date slicer in Power BI Service? UTC timezone issue

%3CLINGO-SUB%20id%3D%22lingo-sub-2926950%22%20slang%3D%22en-US%22%3EHow%20to%20handle%20relative%20date%20slicer%20in%20Power%20BI%20Service%3F%20UTC%20timezone%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2926950%22%20slang%3D%22en-US%22%3E%3CP%3ELooking%20for%20ideas%20on%20how%20people%20solved%20the%20time%20zone%20issue%20between%20Power%20BI%20Desktop%20and%20Power%20BI%20Service.%26nbsp%3B%20I'm%20in%20EST%20so%20when%20I'm%20building%20a%20report%20it%20reflects%20EST%20time%20zone%2C%20but%20then%20when%20I%20publish%20the%20report%20it%20reflects%20UTC%20time.%26nbsp%3B%26nbsp%3B%20Please%20let%20me%20know%20how%20you%20solved%20this%20for%20the%20relative%20date%20slicer%3F%20The%20key%20thing%20is%20how%20can%20you%20make%20sure%20this%20slicer%20performs%20the%20same%20in%20the%20power%20bi%20service.%20For%20example%2C%20at%208pm%20for%20EST%2C%20the%20relative%20date%20switches%20to%20the%20next%20day%20because%20its%20midnight%20UTC%20time.%20So%20if%20you%20select%20prior%20day%20at%208pm%20in%20the%20service%20the%20relative%20date%20slicer%20shows%20todays%20date.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2926950%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Looking for ideas on how people solved the time zone issue between Power BI Desktop and Power BI Service.  I'm in EST so when I'm building a report it reflects EST time zone, but then when I publish the report it reflects UTC time.   Please let me know how you solved this for the relative date slicer? The key thing is how can you make sure this slicer performs the same in the power bi service. For example, at 8pm for EST, the relative date switches to the next day because its midnight UTC time. So if you select prior day at 8pm in the service the relative date slicer shows todays date, but it should be showing yesterday's date.

0 Replies