Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I have used the below DAX
WeekDay = format(Test[FIRST_TOUCH_DATE_TIME],"dddd")
and it gives me this:
Saturday, sunday, Monday i.e Week day names, but I nned to show the name in a sorted order like Monday, Tuesday, Wednesday..
Currently it is hown as below, so how can I achieve this?
Solved! Go to Solution.
Hi @d_sandip59
There is no direct option to sort week day, try to sort manually by the following way-
For more details see the pbix file. Hope this will help you!!!
This will create an error, " A circular dependency was detected".
Hi @d_sandip59
There is no direct option to sort week day, try to sort manually by the following way-
For more details see the pbix file. Hope this will help you!!!
Hi ,
I created a measure and done all the required things , in table the data is sorted but in visual (line graph) it is not sorted . Suggestions appreciated ..!
Thanks .
I have the below two measures I am not getting the sort option in modelling also, I using this in matrix visual.
hi @d_sandip59
Add a new column with the weekday number and then sort Weekday by WeekDay number in Table view
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hi LivioLanzo ,
I tried same as u said but i got an error <refer to img attached>
Please can u suggest anything ??
Thanks .
in the date table create a new column like this
and you need to pull it out onto the matrix instead of your column
Error :
use these -
Thanks Dude .
You are welcome, glad to help.
Even if I try direct connection between week and weeknumber then I found the below error
This is for sorting the column by week day name and not week number so the one I shared it will not work.
Try this -
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |