Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |