Date fields not aligning

[JCK2]

Hello, 

I have created a date filed to use that a master slicer, however for some reason the date field does not seem to be aligned.

Any help is really apprecited 🙂

Not alignedDate propertiesDate properties1

[v-lili6-msft]

hi  @JCK2 

In the first picture, [NC Date Opened] and [Date] are two columns, how do you keep them aligning?

Regards,

Lin

[JCK2 · Accepted solution]

Hello All,

I managed to get it sorted, the reason why it was not aligning was, there was a time stamp in the dates for one and the otherone was showing 00:00:00 instead of actual hh:mm:ss. I forced it to be date, instead of Date/Time and was able to do the user relations perfectly.

Thanks a lot for all your support 🙂

[amitchandak]

If you all dates are in DD/MM/YYYY format then use this setting

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

or you can create new column to convert it into mm/dd/yyyy format

mid(DD__MM__YY[Date],4,2) &"/"& left(DD__MM__YY[Date],2) & "/" & right(DD__MM__YY[Date],4

[tex628]

Hi @JCK2 ,

Could you take another picture where you have filtered both columns on the same date?

Also can you take a picture on how the table relationship looks? 

Br,
J