Relationship between Custom Calendar table and my different colums.

[t-taaror]

Hi All.

I am new to Power Bi and i am currently working on QoS report. I have several unrelated tables in a single report page and i want to have a single date slicer that controls the visuals.

I have already tried creating a calendar table and relating it to my table's column. It always freezes the app. I have acces the SQL server in DirectQuery mode only. 

I also checked whether the data types or formats were same or not.

Any solutions will very helpful. Thanks in advance

[v-cherch-msft]

Hi @t-taaror 

Which means 'It always freezes the app'? Could you share some screenshots about your scenario?If you create a calendar table,you may link it with other tables by date column.If the calendar table is in import mode,you may try to use composite models.

Reference:https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

Regards,