Forum Discussion

Nudo's avatar
Nudo
Icon for Helper I rankHelper I
4 years ago

One slicer with multiple date columns filter

Hey I've been trying this for awhile. I've created a Date Table with relationships to the other columns I want to filter by, but for some reason they only filter to blank. I'm at a loss as to why ...
Need Help
Nudo's avatar
Nudo
Icon for Helper I rankHelper I
4 years ago

So the first 2 images here show if I select blank that picks nearly all the data available, second one I've selected a bunch of days from the start of this year and there's definitely data that would be in that time frame but it's only showing 1.

Other images are just my connections etc

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Nudo 

 

Thanks for that.  Are the "Period" filters you're using in the example from the Date table or are they from your other tables?

 

Theo

 

  • Nudo's avatar
    Nudo
    Icon for Helper I rankHelper I
    4 years ago

    It's the date from the date table

    • TheoC's avatar
      TheoC
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Hi Nudo 

       

      Okay, thanks for that.  I just realised you have bi-directional one to many relationships from your Date table to your fact tables.  Can you turn these into one to many, single direction?  The one should be on the Date table side and the many should be on the fact table side, and the direction should be pointing toward the Fact tables (arrow away from the Date table).  

       

      Let me know whether this corrects the issue once done.

       

      Theo 

       

      • Nudo's avatar
        Nudo
        Icon for Helper I rankHelper I
        4 years ago

        Yea I saw it in a video so tried it out, as I had the previous options you've suggested. But I tried again anyway just incase.

        Just so you're aware the field these 3 options that are showing, are a count of "ID" but I'm trying to filter on created date do I need to do something else here?