Forum Discussion

Helper III

6 years ago

Solved

Date fields not aligning

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

General Comment

JCK2
6 years ago
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 🙂

4 Replies

tex628
Community Champion
6 years ago
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
amitchandak
Super User
6 years ago
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
v-lili6-msft
Community Support
6 years ago
hi JCK2

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

Regards,

Lin
- JCK2
  Helper III
  6 years ago
  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 🙂

Related content