Forum Discussion
One date filter for multiple date columns in one table
NickEccles , you can join both dates one active and another one inactive and use userelation to activate one
Refer this blog how to do
HI NickEccles,
Did your date field succeed recognize as date hierarchy? If this is a case, you can expand the hierarchy fields and extract the year and month fields to create slicers.
If not, you can also check the auto date/time option or create calculated columns with month and year function to extract year and month values form date field.
Apply auto date/time in Power BI Desktop
Function Description YEAR Returns the year of a date as a four-digit integer in the range 1900-9999. MONTH Returns the month as a number from 1 (January) to 12 (December). Regards,
Xiaoxin Sheng
Microsoft EmployeeYou can add a disconnected table with Dates to your model and use that in your slicer(s). You would then have to adapt all your measures to use the selected value ( var slicerdate = selectedvalue(SlicerDate[Date]) and then use it in filter(s) for your measures).
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat