Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
You don't mention how the tables are joined. This information is required to understand the problem.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |