I am trying to connect a single table with a working centralized calendar table. I have created the basic calendar table, marked it as a Date Table, Created relationship between Calendar Table on the Date column and the Change Request table on the sys_created_on column. I still cannot use the calendar table as either a slicer or in a visual to display data by year.I am just trying to get this very simple connection and report to work so I can create a centralized calendar for another report I have with 3 tables that each have 2 dates in them that need to be tracked. Having the same issues on that report so wanted to start by getting something simpler to work as intended. Relationship Setup: Relationship Setup Expected results when using calendar slicer Expected results when using calendar slicer What it shows by default, the top graph uses the date/month from another date filed in the original table, second uses calendar year/month and does not work What it shows by default, the top graph uses the date/month from another date filed in the original table, second uses calendar year/month and does not work Calendar Fileter showing all blanksCalendar Fileter showing all blanks

What is the data type on system_created_dt in Change Request table? If it's a datetime, make sure to change it to date data type in the source or pwoer query.

Centralized Calendar | Microsoft Fabric Community

Open Side Menu

Skip to content

Microsoft Fabric Community
Power BI forums
Desktop

Forum Discussion

Related content

Calendar Slicer with Different Business Calendars

Custom calendar

Tweaking Financial Calendar

Weeknum as per Calendar

Calendar Issue loading stuck