Forum Discussion

JayBI's avatar
JayBI
Regular Visitor
5 years ago
Solved

Relative Time Slicer UTC

Hi all,    Im facing an issue where I am trying to use the relative time slicer but it does not match my timezone.    There are no problems with my data or other visuals that are filtered by this...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi JayBI ,


    For the latest version of powerbi desktop, slicers and filters are always based on the time in UTC, and they cannot be deleted or blocked. My suggestion is that you can use now() to get your time zone, and then create a card visual to illustrate the time zone difference to remind your customers.

     

     

    Regarding your question, I think it is a good idea. I will promptly report back to Microsoft official, hoping to implement this feature in the next update.


    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi JayBI ,

 

The data model in Power BI does not include time zone information. Models can store time, but they do not show the time zone they are in. You can use the query editor to convert data captured in the local time zone to UTC.

 

 

The time offset can be added to the date/time function in DAX through the dax formula. Try as below:

DAX NZ TIME = NOW()+(12/24)
DAX Seattle TIME = NOW()-(7/24)

 

related document link:

Use a relative time slicer or filter in Power BI - Power BI | Microsoft Docs

 

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.