Forum Discussion
Active Relationship always showing blank
Hi bcdobbs, yes I've also check that and they are both already set to the same formatting and everything but it still doesn't work.
However, I finally got it to work by replacing the previsouly selected default Created On column (I also tried the default Modified On column but doesn't work too) with a new date column of the same date format, etc. and it works now. It is so weird but it is displaying the visualizations and is dynamic to the date ranges now.
Hi r3vlock
Ensure that the relationship between your table (with the item counts) and the calendar date column is indeed set as active and that the cross-filter direction is appropriate. Sometimes, even if the relationship is active, the filter direction might not propagate as expected.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
Thanks for your response. Yes, I have ensured that the relationship is active with the correct cross-filter direction but it still always shows blank records. I have double checked the relationships between all the tables with the calendar date column but the one remaining relationship doesnt show records even if I try all other relationship combinations.
I'm still very new to this but I was wondering maybe I may have missed something? Are there other settings that may affect a relationship between two tables? In terms of the direct relationship between them and reviewing the dataverse backend I am sure that the data should be displaying.