how to show month name serially in Pivot Table Data Model & Slicer

[emmr]

hi,

normally month name shows serially in both Pivot Table & Slicer
but in Data Model of Pivot Table & Slicer, month name shows A to Z instead of Serially.

currently im using 01 January, 02 February .... so get it serially, other than that is there have any way to do so.?


NB: attached file for your convenience

TIA

[MarvinP]

Hi emmr,

I'd expect it would be something to do with the Custom Sort Order. See:
https://social.technet.microsoft.com....%20See%20More.
If this link doesn't help, keep asking.

[Bo_Ry]

Add MonthNo in Column J > Add data to the data model


then Select Month Name > Ribbon Home > Sort by Column > Sort Month Name by Month No

[emmr]

its not working MarvinP, thanks for your support

still waiting for the solution (if any)