Forum Discussion
Dynamic Title Field Parameter Multiple selection
Hi!
I'm working on creating a dynamic title that shows all of my selected FieldParameters, in a neat way.
I've currently got it so that it shows all of the parameters I've selected, but they just come after eachother without spaces.
Is there any way to get it so I can display them with perhaps a space and a "&" between each one? Dynamically ofc...
Currenct code:
var _year1 = MIN('dim Calendar'[Year])
var _x = CONCATENATEX('FP BFo', 'FP BFo'[FP BFo])
return
_x & " per " & _year1
Current result: Parameter1Parameter2Parameter3 per 2022
Desired result: Parameter1 & Parameter2 & Parameter3 per 2022
You can pass an additional parameter to CONCATENATEX to act as the delimiter
Title = VAR _year1 = MIN ( 'dim Calendar'[Year] ) VAR _x = CONCATENATEX ( 'FP BFo', 'FP BFo'[FP BFo], " & " ) RETURN _x & " per " & _year1
2 Replies
You can pass an additional parameter to CONCATENATEX to act as the delimiter
Title = VAR _year1 = MIN ( 'dim Calendar'[Year] ) VAR _x = CONCATENATEX ( 'FP BFo', 'FP BFo'[FP BFo], " & " ) RETURN _x & " per " & _year1