Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 -
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |