Forum Discussion
Date Slicer Relation
hello andhiii079845 , all columns in relation are with the same format (Date Time). I guess the issue is with the date columns with no Date hirerachy. Is there a way that I can add Date Hirerachy to such columns ?
Do not use this auto time intelligence function in Power BI. I would prefer to build a own dimensional table for the date (what you do with the calandarauto()) and use this in your model. Than you are able to build your own hirchary in this table with month, days, weeks etc. Do you perhaps do mark the table as date table?
https://www.sqlbi.com/articles/mark-as-date-table/
The problem is not with the Date model i use. I beleive it is mainly with having the relation between this date column (containing a hierarchy) and other date columns with no hierarchy.
The question now is, why do some date columns contain a hierarchy while other don't. knowing that both columns are set as Date time Type. Can you help me with that
In the previous snapshot you can see that the Planned Start date does not contain a hierarchy.
Below table also, the Created Date does not contain a hierarchy while other do.
I even tried the "mark as a date" in Table Tab, but it does not work cuz the data includes events on the same date but with different time.