How to change date format in chart underlying dataset

When exposing underlying data from charts, you can customize how date columns are displayed by adjusting the date format in your dataset settings.

Steps to change date format

1. Open your dataset and navigate to the Formatting tab

2. Click on the date field you want to modify

3. Select custom format in the dropdown under the date format options

4. Set the format to dd/MM/yyyy for DD/MM/YYYY format

Once you've applied this formatting, your chart's underlying data will display dates in the DD/MM/YYYY format instead of the default US format.