cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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?

 

 Sort.png

4 REPLIES 4
Highlighted
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!




Highlighted

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.

Highlighted

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"))

Capture2.PNG

 

 

Regards,
Xiaoxin Sheng

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

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

Announcements
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!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors