Dynamic title sorting

[Anonymous]

I use the following measure to have a dynamic title based on selected filters, and it works fine, but the order is not correct. When I select several values in the year filter, it does not appear correctly. It shows as year: 2020, 2018, 2019. how can I show it in the right order?

Selected Filters  = var _Year= IF(ISFILTERED(table[year]),"| Year : " & CONCATENATEx(

VALUES(table[year]),

table[year],

" , ")," ")
var _birthdate = IF(ISFILTERED(table[BirthDate]),"| BirthDate : " & CONCATENATEx(

VALUES(table[BirthDate]),

table[BirthDate],

" , ")," ") return _Year & " "&  _birthdate

Spoiler

Spoiler

[v-rzhou-msft]

Hi @Anonymous 

Due to I don't know your data model, and have a test by a sample table and your measure.

My Sample table:

Your measure result:

It seems to work well. By default it will order your value by asc.

Could you show me your datas and data model by a sample?

Or you can share your pbix file with me by your Onedrive for Business.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[DataZoe · Accepted solution]

@Anonymous did you see this solution Solved: I want to "Order by" before using CONCATENATEX ...... - Microsoft Power BI Community?