How to display public holidays on Time Series and other charts?

Data Studio Data Studio Q&A
1

Hi,

What’s the recommended way to display public holidays in Data Studio, especially on Time Series charts?

I’d like to highlight holiday dates to better understand traffic/booking trends. Is there a native solution, or is the best approach to create a calendar table (e.g. in BigQuery) and join it with the reporting data?

I’d also be interested in hearing how others handle this in Combo Charts and other visualizations.

Thanks!

2

Hi @szakacsmark

There is no native solution.
You can apply my old but still relevant recipe described in the article below for annotations, that can work also for public holidays.

https://www.withdatastudio.com/blog/custom-reports/20200401-google-data-studio-annotations-as-in-google-analytics/

I hope it helps.

Mehdi

3

Thank you very much! I’ll check it out!