March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello Community,
Current issue is the following :
a) I have a table with records, one of the fields is the creation date of the record
b) I have a time table covering every days until today --> on purpose, there is an inactive relationship betwee the date field of my time table and the creation date of the records table
c) I want to display a visual table of the records created in a period of time --> I use a slicer, relative date, let's say "last 1 week"
d) In order for my visual table to respond to the slicer, I add in filter a measure that must be greater than 0 :
Solved! Go to Solution.
I found the issue... It was due to another relationship active on my time table causing the data to disappear.
I found the issue... It was due to another relationship active on my time table causing the data to disappear.
Elorian - Without seeing the data types in your specific tables, it's difficult to provide a definite answer. However, it would seem that the issue is in the relationship between your two tables.
I would check the related fields in the creation date and the time table. If the time table contains a date/time field and the creation date is a date field, then you will drop records when you try to join.
Hello,
I thought about that but it's not the case (or I missed something). The rough data of the records, indeed, the creation date is of date/time format but, through Power Query, the format is changed in a pure date (and my date in the time table is also a pure date, of course).
Kr,
Erwin.
PS : cannot provide a data set for GDPR and policy reasons but lets say that you have something like, for my record table, simplified :
REQUEST_ID | CREATION_DATE |
Record 1 | 13/09/2022 |
Record 2 | 13/09/2022 |
Record 3 | 13/09/2022 |
Record 4 | 14/09/2022 |
Record 5 | 14/09/2022 |
Record 6 | 14/09/2022 |
Record 7 | 14/09/2022 |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
165 | |
116 | |
63 | |
57 | |
50 |