Date field showing as Number in combo table

[#1]

Hi all,

I'm creating  a milestone tracker in a combo chart. My date is coming in from excel as a date format 'YYYY-MM-DD'. Below is a list table of the dates:

Whenever I try to add these into a combo chart to match the "Activity Name", the date along the bottom is shown as a number

The dimension for the combo chart is "ActivityName" and the expression is:

if(([baselineFinish]) >= today(), max({<[milestoneLevel]={'Silver'}>}([baselineFinish])),null())

Even when I hover over the milestone, it picks it up as a date:

I've tried adding Date(baselineFinish, 'YYYY-MM-DD') as baselineFinish in my load script, I've changed the format of Today() to be 'YYYY-MM-DD', I've tried setting the axes as static today(), I've changed the number format in the document settings to be a date format  and nothing works!

Any help would be much appreciated.

Cheers

[vishsaggi · Accepted solution]

While loading from Excel. Try to change the date format like:

Date(Date#(BaselineFinish, 'YYYY-MM-DD'), 'YYYY-MM-DD') AS BaselineFinish

OR

Date(Floor(BaselineFinish), 'YYYY-MM-DD')