Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have some SQL DirectQuery data inputted into my PBI Desktop. The data has a date column ("mm/dd/yyyy") and some corresponding data in the subsequent columns. I wanted to get the data in a weekly glance (i.e. show the data by day from Monday - Friday of the current week).
To do this, I created a calculated column - assigning each date a day using the WEEKDAY() function. However, the days are sorting out of order. See the picture below:
I made this column so that it would display the actual day instead of the integer representing it. As you can see, it is sorting out of order. Is there a way to sort it in the actual order?
Thanks,
Farhan
Solved! Go to Solution.
Hi @farhandsome ,
Regrads FrankAT
Hi @farhandsome ,
Regrads FrankAT
Have you tried to sort the named day column by the numeric day column ?
Ricardo
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |