Weird date slicer bug

[Anonymous]

Hi

Sadly I can't show any examples because of sensitive data so I'll try to explain as detailed as possible.

I have 3 table visuals and 1 date slicer - all data comes from 1 sql table.

Date slicer right now starts with 25.jan until today, updates everyday.

1st table:

Item ID	ID	Date	Status	Imei code	Table1 ID
F214	2	25.01.2021 14:11:25	Passed	5921582185218	14
F521	5	28.01.2021 12:41:45	Failed	5621622162151	12
F621	3	26.01.2021 19:21:52	Failed	5219952195925	11
F871	3	25.01.2021 11:42:11	Passed	5215215661214	25

2nd table: ( shows total scans )

Item ID	Scans	Passed scans	Failed scans
F871	192	173	19
F621	70	60	10
F521	20	10	10
F214	5	3	2

3rd table: ( shows failed scans only )

Item ID	Table1 ID	Quantity	IMEI code	Description
F521	12	1	5621622162151	Some old junk
F621	11	2	5219952195925	Some more junk

Now when I have my date slicer from min to max ( showing all data avaivable ) and I click on table 1 on row item ID F521 for example then all the other tables refresh correctly, showing the data about this 1st table pick only. 

However when I move the slicer and choose 1 specific date for example 28.01.2021 it once again refreshes all tables correctly accordingly to that date BUT when I click on F521 in table1 the other 2 tables show blank but should show data about F521. ( Remember it does this correctly when I don't touch the date slicer. ) 

I already checked: If "Edit interactions" isnt blocking some data <- it's not- turned to "filter" in every table.
I added Date column to other 2 tables aswell to see if maybe the dates are somehow wrong but no it shows the exact date and time.
Since data comes from same table there can not be and relationship problems. 
There are no filters. ( Note when I tried to filter out 2 useless items from table 1 then it broke for some reason even when date slicer wasn't touched - didn't show any data on any other table when 1 item was selected in table 1 - don't know why )

My question is how can it work correctly when date slicer is not touched but brakes after date slicer is modified while all data comes from same table. - no custom columns either.

Note2: When I remove Date column from table1 then other tables refresh correctly even if date slicer is modified. 
Note3: I only have 1 date column that I use.

[MattAllington]

You don't mention how the tables are joined. This information is required to understand the problem. 

[Anonymous]

Joined? What do you mean by that? Theres 1 table from SQL DB with 10 columns, there aren't 2 tables. Sorry my initial post was confusing, fixed it

[MattAllington]

Oh, you have 3 table visuals, not 3 tables. That's different. You need to build a dimensional model. Create a calendar dimension table and an item dimension table - both tables should contain all the unique values from your date column and items column. Join them with a 1 to many relationship dim to the main table. Then put the slicer on the date dim table and another on the item table. See how that goes.