Date Dimension not working properly

[kasiaw29]

Hi community,

I have a simple date dimension table, build it as a new table + some columns for the usual day, month, week no, etc.

Date Dimension = CALENDAR(DATE(2016,1,1),DATE(2099,12,31)) 

I also have a facts table, in this example called Payment Milestones with 1-many relationship:

  

Payments milestones can have few payments occurring on the same date, so naturally I wanted to see how many and which ones fall on what day, but this does not seem to work when put on a simple bar chart:

 

Anyone any ideas?

[kasiaw29 · Accepted solution]

Nevermind. The issue was sorted in power query...trying to match date and time to date.