Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic title sorting

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
 
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.