Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
Elorian
Resolver I
Resolver I

Date slicer applied on a table/matrix visual but no data shown for the today date

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 : 

+Count Request vs Creation date =
    CALCULATE(
        COUNT(REQUEST[REQUEST_ID]),
        USERELATIONSHIP(_TimeTable[Date],REQUEST[CREATION_DATE])
    )
 
==> All this works super well if I make the visual table with the record references and the creation date fields coming from my records table
==> BUT, if I want to add some details in the table coming from my time table (like, for instance, the corresponding week), as soon as I add in the visual table a field of my time table, the records of today disappeared (and only those ones)!
 
Can someone help me to understand what's happening, please?
 
Thanks in advance for your help,
Elorian.
1 ACCEPTED SOLUTION
Elorian
Resolver I
Resolver I

I found the issue... It was due to another relationship active on my time table causing the data to disappear.

View solution in original post

3 REPLIES 3
Elorian
Resolver I
Resolver I

I found the issue... It was due to another relationship active on my time table causing the data to disappear.

kencolecma
New Member

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_IDCREATION_DATE
Record 113/09/2022
Record 213/09/2022
Record 313/09/2022
Record 414/09/2022
Record 514/09/2022
Record 614/09/2022
Record 714/09/2022

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.