Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
How do you keep the Months properly sorted in order (from Jan-Dec) but also show the top # from top to bottom in the Count? In Excel it's easy but in PBI I am having trouble finding a solution.
@chillpill , You need to have a sort column for month
Month = FORMAT([Date],"mmmm")
Month sort = month([DAte])
mark month sort as sort column for month
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Not sure I follow because I already sort the Month column by Month Number (as you describe above), but the items underneath the Month in the Matrix I am unable to sort in Descending order while maintaining the correct order of the Months..
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.