Forum Discussion

cazza's avatar
cazza
Frequent Visitor
1 year ago
Solved

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...
Need Help
  • hnguy71's avatar
    hnguy71
    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!

cazza's avatar
cazza
Frequent Visitor
1 year ago

Hi,

 

I was under the impression that if I had a bideirectional filter, the Year slicer would only show the latest year, so in this case 2025.  This is how I've alwasy managed to get the slicer to only show the relevant date range without restricting the date dimension itself.  I might have completely misunderstood how this should work?