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
TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Nudo 

 

Can you provide some screenshots or examples to help us give you a solution?

 

Thanks heaps,

Theo

 

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