Forum Discussion
Fact Table Not Filtering Date Dimension Table
- 1 year ago
hi cazza
You can create measures or other filters, then add it to your slicer and show only the relevant dates in scope but typical behavior is slicer filters all other page visuals, not the other way around.Also, having a bi-direction from your date table to your fact table(s) are usually avoided because other factors from your other dimension(s) may influence or cause issues in getting the right results. I'm sure there are probably some use cases but from the hundreds of semantic models that I've created, none of them has a bi-direction to my date / calendar table.
Hope that helps!
Hi @cazza ,
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Regards,
Chaithanya