Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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?
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
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
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |