Forum Discussion

pdstats's avatar
pdstats
Frequent Visitor
9 years ago
Solved

time relationship

I'm having a difficult time creating a relationship between two tables.  The relationshop is based on time (HH:mm).  One table is created from excel and the other is from SQL database.   Excel 00:...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    pdstats

     

    According to your description, I have reproduced your issue. Only Blanks have matches in the Slicer like below.

     

    The issue got fixed after I changed the type of Time(column in table from Excel) from Date/Time to Time in Query Editor. 

    The Slicer works fine like below.

    Regards

pdstats's avatar
pdstats
Frequent Visitor
9 years ago

The time table has unique value containing 24 hours.  I receive no errors.  But when I filter, only blanks have matches.  It's almost as if there are no matching values between the two tables.  I can create the relationship successufly with no errors.

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

pdstats

 

According to your description, I have reproduced your issue. Only Blanks have matches in the Slicer like below.

 

The issue got fixed after I changed the type of Time(column in table from Excel) from Date/Time to Time in Query Editor. 

The Slicer works fine like below.

Regards

  • pdstats's avatar
    pdstats
    Frequent Visitor
    9 years ago

    You sir are a genius!   I've changed field to time by going into properties within PBI main screen, not the query editor.   After looking at your screens, I realized that I should be changing it within the Query editor.  As soon as I made the change, the result appeared correctly.  Thank you very very much!!!!