continuous x axis labels show month - need one label per date

[hugus]

Hi All

i have a line and stacked column chart - # sales on y-axis and date (DD/MM/YYYY) on x.

i can only seem to get the labels on the x-axis for MONTH.....i want to have a label per date.....and it is continuous data.

have seen a few other threads that didnt really come up with a solution. surely i can get a label every date....or at least chose a label every N dates....??

[v-shex-msft · Accepted solution]

HI @hugus ,

if your date field is in hierarchy mode, you can click on 'expand all level' icon to expand all hierarchy fields.
In addition, you can also switch date column to normal mode, it will display all records instead summarize records by hierarchy.

Regards,

Xiaoxin Sheng

[hugus]

heirachy did it - thanks!!