Changing the Date format depending on the type of component.
For a slicer
To format the date.
Select component containing the date field.
Go into Inspector and change “Data Format”.
Choose a predefined format or create your own.
Scroll down to Custom and edit the format in the Type: field.
For Table and Chart Components
Change the data field properties.
Select component containing the date field.
Select Exact Date.
Change the data field properties in Data Binding.
In Data Binding click on the cog , Edit Format…
and/or
Edit format.
Scroll down to Custom.
In Custom choose how the date is displayed, edit Type: field
Change the date display
When adding Date fields (where available) from 1 per column i.e day - Month - Year to show in the same column as one entry.
Select component containing the date field.
Select Exact Date.
Examples of Date Formatting
Day | Month | Year |
dd = 13 | mm = 11 | yy = 23 |
ddd = Mon | mmm = Nov | yyyy = 2023 |
dddd = Monday | mmm = November |
|
Format | Output Result |
dd mm yy | 13 11 23 |
ddd/mmm/yyyy | Mon/Nov/2023 |
dddd-mmm | Monday-November |
PRO TIP: You can use any divider - Slash or dash ""/" "-" or none
e.g. dd-mm-yy - dd/mm/yyy - dd mm yy