The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
78 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |