Forum Discussion

ogghall's avatar
ogghall
Frequent Visitor
8 years ago
Solved

Dynamic title does not list months selected in chronological order

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. F...
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

ogghall,

 

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

  • ogghall's avatar
    ogghall
    Frequent Visitor
    8 years ago

    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