Forum Discussion
Charticulator :Datetime in X-axis does not relate to plotting area and displays a different date
Thank you for your reply! First thing i used is temporal only
I did found the issue, Charticulator coverting the datetime to -8 hrs. Probably its due to my locale which is GMT8 so it is converting to GMT is my assumption. As of now i am controlling this in data model by adding +8 hrs which is not the correct way
I am searching for a D3 date format to use in tick format which results in GMT8 timings , please let me know if you are across it
Super UserGlad you have a handle on the issue. I typically work with dates rather than date + time, so I don't have any solid advice here.
To manage an offset via Charticulator may be tricky using just a format specifier. IIRC, the %Z specifier allows you to parse an offset, but it might not adjust it - I'm not sure if this will help at all?
Given the need to sometimes provide 'design' or 'display' measures to give Charticulator specific data points to work from (much like you might use for conditional formatting of visual titles etc.), offsetting via DAX is not necessarily a bad thing, provided that it's clear what the measure or column is being used for. However this will depend on your modelling policies, and I appreciate this may not be an option for you.
If you need to handle transformation of data in-visual, another possibility may be Deneb; this is lower-level than Charticulator but as Vega & Vega-Lite have their own expression language, they have support for handling offsets as part of their transform functionality.
Good luck,
Daniel