Forum Discussion
Relationship between Custom Calendar table and my different colums.
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
1 Reply
v-cherch-msftMicrosoft Employee
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,