Show Date Slicer results in Text box ordered by Year then Month.

[AP23]

Hello all, 

I have trawled the forum looking for an answer but haven't found quite what I need, therefore I am hoping someone can help me directly please.

I have a slicer which shows the Year and Month. Users can select multiple months.

I want to display the results in a text box showing the Year(1) and associated months and Year(2) and associated months e.g.

2023: November, December

2024: January

I've seen many ways of concatonating the months which I've got working, but the years are then out of order

For example:

var A = CONCATENATEX ( VALUES ( Child[data.startDate].[Month] ) , [Month] , " | ")

var B = CONCATENATEX ( VALUES ( Child[data.startDate].[Year] ) , [Year] ,  " | ")

var C= UNICHAR(10)

return

A & C & B

which results in the following:

I've also tried using Min(month) and Min(year) & Max(month) and Max(year) but this results in e.g.

"January 2023 to December 2024" 

How can I achieve the desired result please? Many thanks in advance.

[amitchandak · Accepted solution]

@AP23 , Try to avoid auto date hierarchy.

Measure =

var _max = maxx(allselected(Child), Child[data.startDate])

var _min = minx(allselected(Child), Child[data.startDate])

return

format(_min, "mmmm-yyyy") & " to " & format(_max, "mmmm-yyyy")

[AP23]

Thanks so much. Simple when you know how!!

Works perfectly 🙂