Forum Discussion
Helper IVDynamic Order in Title
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
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
3 Replies
- lbendlin
Super User
works for me
You probably forgot to specify that you want to sort "Response" by "Ranking"
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
DW868990Fantastic, working now. thank you
