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
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!