Forum Discussion
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.
8 Replies
Hi,
Share the download link of the PBI file and show the problem clearly.
I found that the relationship works only with date/time columns that contain the Calendar Logo). I do not know if this is relevant or why this logo appears on some date/time columns and not all. Apologies if the question seems dumb and appreciate your help.
Perhaps one column is formated as text? Show us please more about the not working table.
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/
andhiii079845 , I have tried the relationship with a date containing a hierarchy and it did not work, so i beleive my theory was wrong.
Below is the relationship model with the Date Table. Only the UptimeYTD results are working as intended. While any visual from All Tickets table or Changes Table are not functioning correctly
