Need Help with Date Modeling

[tejapowerbi123]

Hello Community,

I need help with Data Modeling, here is my data model.

I want to display “INCIDENT CATEGORY” from Incident Table and “Task Category” from Task Table together on “Table or Matrix Visual” and “Date” slicer from Data Table.

I tried to changed Cross Filter Directions to “Both” but it is not working.

***Please note I have multiple columns in both tables and need to move on table and matrix visualization

Incident Table

Date	Incident Category
01-Jan-22	A
02-Jan-22	B
03-Jan-22	C
04-Jan-22	D
05-Jan-22	E
06-Jan-22	F
07-Jan-22	G
08-Jan-22	H
09-Jan-22	I
10-Jan-22	J
11-Jan-22	K
01-Jan-22	L
02-Jan-22	M
03-Jan-22	N
04-Jan-22	O
05-Jan-22	P
06-Jan-22	Q
07-Jan-22	R
08-Jan-22	S
09-Jan-22	T
10-Jan-22	J
11-Jan-22	K

Task Table

Date	Task Category
01-Jan-22	1
02-Jan-22	2
03-Jan-22	3
04-Jan-22	4
05-Jan-22	5
06-Jan-22	6
07-Jan-22	7
08-Jan-22	8
09-Jan-22	9
10-Jan-22	10
11-Jan-22	11
01-Jan-22	12
02-Jan-22	13
03-Jan-22	14
04-Jan-22	15
05-Jan-22	16
06-Jan-22	17
07-Jan-22	18
08-Jan-22	19
09-Jan-22	20
10-Jan-22	21
11-Jan-22	22

***Date Table has data from 01/01/2022 to 12/31/2022

[tejapowerbi123]

@amitchandak  In my scenarios I have a date table which is my Bridge Table.Still it is not working

[amitchandak]

@tejapowerbi123 , Create a table and join with both columns

refer : https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

[tejapowerbi123]

@Here is my data model as per your suggestions,still not working.