Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
hi all.
i have this table below, is there a way to sort the date in sequence?
The ascending and descending order was greyed out.
Thank you.
Solved! Go to Solution.
Please check the file I shared. I changed the year to the range and it is sorting correctly.
As suggested by @Greg_Deckler .
Add a column like
Month year sort = format(Date[Date],"YYYYMM")
And mark it as the sort column
File is attached
Please check the file I shared. I changed the year to the range and it is sorting correctly.
You need to add a column in your Power Query that you can use for sorting and then use Sort By on your column in Power BI Desktop
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
91 | |
81 | |
65 | |
65 | |
60 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |