cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper IV

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?

1 ACCEPTED SOLUTION
Impactful Individual

@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 4
Impactful Individual

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

Helper IV

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

Kind regards,
Alessandra

Impactful Individual

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

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

Announcements

Fabric certifications survey

Certification feedback opportunity for the community.

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors