Help with Date slicers

[DCrowther]

Hi

I need help with created a dashboard date slicer/filter that will cover another of tables with date fields, all the tables are different how ever i would like the table to report all the tables on the same date period (i.e. March 2019). Isd there a way to to have one slicer that covers many different date fields across many tables?

[Anonymous · Accepted solution]

Hi @DCrowther ,

You can create a date dimension and create relationship with all other dates with all tables. Then use date field from date dimension. After that date filter will be applicable for all tables which is joined with date dimension.

Use below DAX to create a date dimension

DimDate = CALENDAR(DATE(2018,1,1),DATE(2019,12,31))

Please check and if this helps then mark this as solution so that other can find immediately. Aslo give kudos.

Thanks,

[DCrowther]

Many Thanks

Yes having all selected date fields connected to/Related to the date field in a date Dimension table appears to fix the problem and then allows the date slicer to control other related date tables

Thanks for your help