Hi i create dashboards for my data on a monthly basis and i need to be able to sort the calendar months in calendar month order. How do i do this?
In addition, i would like to change another chart to show percentage total against month rather than 'grand total' or 'Count' please help
@ For your question 1 sorting order @amitchandak has answered it so try that out. And regarding your second question please do the following as per screen shot. So that will give you % of total.
@ , You need to have sort column
Month Year = FORMAT([Date],"mmm")
Month Year sort = month([DAte])
Mark Month Year sort as sort column of Month Year
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Fabric Community Sticker Challenge - Barcelona 2026
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Power BI Monthly Update - July 2026
Check out the July 2026 Power BI update to learn about new features.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
