Forum Discussion
cazza
1 year agoFrequent Visitor
Fact Table Not Filtering Date Dimension Table
Hi all, I have been trying really hard to figure this one out but to no avail! I have experience building dashboards in the past so can't see what I'm doing that is making this happen! I hav...
- 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!