Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to Solution.
@alevandenes You can use this way .
step 1 : Create a Calender using below dax .
or Step 2 Create A new column using these dax function .
@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 :
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
@alevandenes You can use this way .
step 1 : Create a Calender using below dax .
or Step 2 Create A new column using these dax function .
@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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
94 | |
89 | |
35 | |
35 |
User | Count |
---|---|
153 | |
99 | |
82 | |
63 | |
54 |