Add weekday to hierarchy

[alevandenes]

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?

[HarishKM]

@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]

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 · Accepted solution]

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

[amitchandak]

@alevandenes , You might have to create a date table and create a custom hierarchy

Custom Hierarchy
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY