Forum Discussion

AlexKahler's avatar
AlexKahler
New Member
6 years ago
Solved

Filtering a table in a cascading relationship

Hi everyone,   I'm having issues with filtering a table in a cascading relationship. E.g., Table A has a slicer with dates and a 1-* relationship to table B. Table B has dates and id, with a 1-* r...
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  AlexKahler 

    From your screenshot of relationship, it should works well.

    I think the problem should be that

    Master Date table is used DAX, so it will only have 12:00:00AM time for each date,

    [Visit date & time] must have different time not just 12:00:00AM time for each date,

    you just change the format of them to make them same.

    So although you have create a relationship between them, but they are not same for each date.

     

    Just add a date column for [Visit date & time]

    Date = DATE(YEAR([Visit date & time]),MONTH([Visit date & time]),DAY([Visit date & time]))

    Then use this column to create a relationship instead of [Visit date & time].

    Now it should work well.

     

    Regards,

    Lin

AlexKahler's avatar
AlexKahler
New Member
6 years ago

Unfortunately, I can't as the data is NDA.

 

I've taken a new screenshot of the actual relationship in Power BI.

 

 

This is what happens, when I filter the report. I made sure that the datapoints for the visualizations are the same tables as above.

And, in the tables, I can see that the date range is correct;
Here's from Visit Info;

And in Master Date;

 

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  AlexKahler 

From your screenshot of relationship, it should works well.

I think the problem should be that

Master Date table is used DAX, so it will only have 12:00:00AM time for each date,

[Visit date & time] must have different time not just 12:00:00AM time for each date,

you just change the format of them to make them same.

So although you have create a relationship between them, but they are not same for each date.

 

Just add a date column for [Visit date & time]

Date = DATE(YEAR([Visit date & time]),MONTH([Visit date & time]),DAY([Visit date & time]))

Then use this column to create a relationship instead of [Visit date & time].

Now it should work well.

 

Regards,

Lin

  • AlexKahler's avatar
    AlexKahler
    New Member
    6 years ago

    Hi,

     

    Thanks a lot! This solved the issue.

     

    I made a custom column as you described and it work perfectly!