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, but i never get what i am actually looking for. Any ideas on how to tackle this?

 

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").

4 Replies

  • 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").