Forum Discussion

anjcampo's avatar
anjcampo
New Member
2 years ago

Year Slicer

Hi Can someone know how to create A Dax measure to year slicer using 3 date columns in different table (3 table), the matrix is showing month values and I would like to have the 1 (Year) slicer visual for the 3 matrix visuals. Thank you.

1 Reply

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    2 years ago

    anjcampo 

    Create a dates table and connect (using relationship) it to those three tables, then you will be able to use the Year column on the slicer to filter all the visuals.


    Here is the code to create a dates table, chagne the date range as needed:

    Dates = ADDCOLUMNS(
   CALENDAR("01/01/2022","31/12/2022"),
   "Month No" , MONTH([Date]),
   "Month Name" , FORMAT( [Date] , "Mmmm" ),
   "Year" , YEAR([Date]),
   "Month Year No" , (YEAR([Date]) * 100) + MONTH	([Date]),
   "Month Year" , FORMAT( [Date] , "Mmm yyyy"),
   "Quarter" , QUARTER([Date]),
   "Year Qtr" , FORMAT( [Date] , "YYYY \QQ"),
   "Week Day" , WEEKDAY([Date],2),
   "Week" , FORMAT( [Date] , "Dddd" )

)