DAX for months selected in a filter - sorting the concatenated list

[ruthhacche]

I am concatenating a string to show the months selected in a filter.

I have FiscalMonthNames which run from June to May and display in visuals sorted by a FiscalMonthNo column (January = 8).  The filter on the page starts at June.

The string works fine up until I include January which appears before June. - it is not sorting alphabetically (which I could understand) -  it is sorting by calendar month - where is it getting that from?  Is there a piece I can add to this DAX that will do the sort before I concatenate?

Months Selected = IF(

ISFILTERED('Calendar'[FiscalMonthName]),

VAR months = FILTERS( 'Calendar'[FiscalMonthName])

VAR string = CONCATENATEX(months,'Calendar'[FiscalMonthName],", ")

RETURN string

)

[parry2k · Accepted solution]

@ruthhacche yes you can pass the order by column to get the proper sorting. see example below:

Measure = CONCATENATEX ( ALLSELECTED ( Mnth ), Mnth[Month], "," , Mnth[Sort])

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡