why date column cannot show date icon?

[Anonymous]

  my data from NAV system, in the same table, why some date column show with Date icon, other cannot show with data icon?  I need "Posting Date" to show with date type, then can use at my report, all of that column I setting with date type, Is here anyone can help me to fix this issue? Thank you in advance.

[703318180]

Hi have only one data set and it is not showing date icon in from of column. I have checked in power query too , it is marked as date column there.May I know why it is ?

[drupalgirl]

Thanks @v-chuncz-msft !!

[v-chuncz-msft · Accepted solution]

@Anonymous,

This might be caused by the relationship.

https://community.powerbi.com/t5/Desktop/Date-Hierarchy-falls-to-appear-when-joining-on-the-date/td-p/257605