Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
Solved! Go to Solution.
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
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
Of course... thanks!
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.