Forum Discussion

DCrowther's avatar
DCrowther
Helper I
7 years ago
Solved

Help with Date slicers

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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's avatar
DCrowther
Helper I
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    DCrowther
    Helper I
    7 years ago

    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