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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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
Top Kudoed Authors