Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Sorting of months in cross tab

Hi all,


I have an issue with sorting of months in a cross tab.Need to display the year and month.


But by default it is displaying in alphabelital order. Do we have any work around?



Super User I
Super User I

in your modelling tab set the monthname  column to sort by column by month number Capture.PNG

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Thank you vanessafvg. I tried it but still it is displaying in alphabetical order.


My requirement is that the month should start with April. So for the financial year it will be 2016-Apr,2016-May and so on


till 2017-Mar.


The Year should be appended along with the month name.i tried sorting on year month number like 2016-04. it does not work even


if i remove the year.


Hi @sudhakar111,


You can try to add a calculate column to convert financial date to numeric, then drag above column to columns field, it may fix the issue.


Numberic Fiscal Date = VALUE(FORMAT([Date],"yyyymm"))




Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Thanks for the response. But i need to display the months as 2016 - Apr,2016 - May and so on and not in numbers.

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors