One slicer with multiple date columns filter

[Nudo]

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 they won't filter on the date. 

[Anonymous]

Hi @Nudo ,

Please show some sample data so that we could reproduce the scenario.

Best Regards,

Jay

[TheoC]

Hi @Nudo 

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

Thanks heaps,

Theo

[Nudo]

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]

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]

It's the date from the date table

[TheoC]

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]

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?

[TheoC]

@Nudo thanks for letting me know!  In terms of the IDs, are they in the fact tables that the Date table is related to?

[Nudo]

Yea so its the ID of the row that has the created date that I've related to the date table. 

[TheoC]

Thanks for that @Nudo - in terms of the Inspections and Converted Leads, are these a measure? 

[Nudo]

Nope, objects from Salesforce so a row is a certain Inspection/Converted Lead with columns being all the info associated with that object etc created date, name