Forum Discussion
Common Single Date Slicer
Hi all, Please help with the below scenario: How to make common single date slicer for 3-4 visuals for which data is coming from different datasets. I have 3 different datasets A,B and C and in...
Hi 12-pune
We can create a common dimension table for dates by using DAX functions like CALENDARAUTO() or CALENDAR(mindate, maxdate)
And then create relationships between the calendar table we just created and other tables based on begin_date or end_date as per your requirement. Use calendar table Date column in slicer to make it work.
If this doesn't help, please provide sample pbix with dummy data to understand the issue better.
If this helps, please accept my response as solution. 👍