Dynamic Order in Title

[DW868990]

Hi,

I have a dynamic title that shows up to 6 responses per end user selection. The selection is made via a slicer of table like below. 

Now i have used CONCATENATEX within the measure of the title so it does show the end user selections, but I need it to show in order of the ranking column above. It seems CONCATENATEX can only be ordered by a measure, not a column, or am i missing something? Thanks in advance.

JJ

[DW868990]

Fantastic, working now. thank you

[v-yiruan-msft · Accepted solution]

Hi @DW868990 ,

You can create a measure as below to get it by using CONCATENATEX function , please find the details in the attachment.

Title = 
CONCATENATEX (
    ALLSELECTED ( 'Table' ),
    'Table'[Response],
    ",",
    'Table'[Ranking], ASC
)

Best Regards

[lbendlin]

works for me

You probably forgot to specify that you want to sort "Response" by "Ranking"