Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi everyone, I was wondering why sorting of dates are not working when 'switch values to rows' are on using Matrix Visual? See below snapshot for reference. Thanks in advance 🙂
Sorting of Daily dates not working
Hi @ronaldbalza2023,
Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Can you show what you expect to happen? In the first snippet it looks like the dates are sorted in ascending order.
@russell80 thanks for taking the time on this. My bad, I attached the wrong snippet. I have updated the post. Basically, it is not sorting on daily dates.
| User | Count |
|---|---|
| 23 | |
| 20 | |
| 19 | |
| 18 | |
| 10 |
| User | Count |
|---|---|
| 53 | |
| 53 | |
| 40 | |
| 37 | |
| 32 |