Forum Discussion

kasfour's avatar
kasfour
Icon for Helper I rankHelper I
3 years ago

Date Slicer Relation

Hello,          I have a Date Table "Date = CALENDARAUTO()" that I linked (relation) to different dates on other data sets. However, the date slicer only works with one of them. Please help. ...
Need Help
andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

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/

 

 

kasfour's avatar
kasfour
Icon for Helper I rankHelper I
3 years ago

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