How to Display dates in local time zone

I would use relative filters with UTC time and have all of your visuals use BST time with a calculated field.

As of answering this question, it is 3:20PM. The latest event was at 1pm central time. And my timestamp field is in central time. However, if I filter for the past 3 hours in QuickSight nothing comes up because it is in UTC.

If I go back 8 hours it will show the events that came back for that hour.

If I casted this timestamp field to UTC it would add 5 hours and then my last 3 hours filter would work.

In conclusion, I would use the UTC timestamp as a field to filter on. And then use a newly created calculated field as the field you use for your x / y axis / tables.

Let me know if that helps or answered your question!