Dynamic title does not list months selected in chronological order

[ogghall]

I have a dynamic title that changes with the months selected from either a slicer or from the drill down in the chart. The months when they appear in the title do not appear in chronological order. For example when first 3 months are in title it is "Mar, Feb  Jan" If I also selct April, Apr comes after Jan in title.

How can I get months in title to appear in order?

[v-chuncz-msft]

@ogghall,

The CONCATENATEX function can have optional parameters to define the order of the table to use to concatenate values in a string.

[ogghall]

@v-chuncz-msft

I am not very experienced with the writing of parameters. How would I write the additional parameters for the sorting  with this as my Concatenatex?

CONCATENATEX(AllButLastSelectedMonth,Paudits[MonthOnly],

Thanks

[v-chuncz-msft · Accepted solution]

@ogghall,

You may take a look at link below.

http://www.excelnaccess.com/concatenatex/

[RMDNA]

@ogghall,

How is the dynamic title calculated?

[ogghall]

@RMDNA

The column used to provide the month is a formatted column providing the month which is referencing a column with the entire date in it. dd/mm/yyyy to mmm