Forum Discussion

alevandenes's avatar
alevandenes
Icon for Helper IV rankHelper IV
5 years ago
Solved

Add weekday to hierarchy

Hi,    In the column of a table graph i have a hierarchy (month, day) - as shown below. I would like to specify also the weekday (mon, tue, wed, thu, fri, sat, sun). I have tried different options,...
Need Help
  • HarishKM's avatar
    HarishKM
    5 years ago

    alevandenes  You can use this way .
    step 1 : Create a Calender  using below dax .

    Calender = ADDCOLUMNS( CALENDAR(MIN(data[Order Date]),MAX(data[Order Date])),
    "Year",YEAR([Date])
    , "Monthnum",MONTH([Date]),
    "Month Name ", FORMAT([Date],"mmmm")
    , "Day", DAY([Date]),
    "Day of Week ", FORMAT([Date],"dddd")
    )
    and create a custom hierarchy like month name , Day ,day name . then drag that in your calculation matrix .
    * Tested on a sample public dataset 


    or Step 2 Create A new column using these dax function .

    "Day of Week ", FORMAT([Date],"dddd").
HarishKM's avatar
HarishKM
Icon for Super User rankSuper User
5 years ago

alevandenes You can go to transform data then click on

table name => Work data coloumn => Add coloumn then date => name of the day => you will get name of the day column name => close and apply once loaded then drag that in your work date slicer =>Bingo..


Final solution :

 

 

  • alevandenes's avatar
    alevandenes
    Icon for Helper IV rankHelper IV
    5 years ago

    Hi HarishKM 

    this is my starting point (see screenshot below). the thing is i dont want to lose the day number. I would like to see both that and the weekday. 

    in the way that you proposed, results would be grouped into weekdays but in this case i would like to keep them separated into days

     

    Thanks a lot already for your support on this

    Kind regards,
    Alessandra

    • HarishKM's avatar
      HarishKM
      Icon for Super User rankSuper User
      5 years ago

      alevandenes  You can use this way .
      step 1 : Create a Calender  using below dax .

      Calender = ADDCOLUMNS( CALENDAR(MIN(data[Order Date]),MAX(data[Order Date])),
      "Year",YEAR([Date])
      , "Monthnum",MONTH([Date]),
      "Month Name ", FORMAT([Date],"mmmm")
      , "Day", DAY([Date]),
      "Day of Week ", FORMAT([Date],"dddd")
      )
      and create a custom hierarchy like month name , Day ,day name . then drag that in your calculation matrix .
      * Tested on a sample public dataset 


      or Step 2 Create A new column using these dax function .

      "Day of Week ", FORMAT([Date],"dddd").