Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

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

View solution in original post

2 REPLIES 2
johnt75
Super User
Super User

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
Anonymous
Not applicable

Of course... thanks!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors