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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
thne123
Helper I
Helper I

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

Of course... thanks!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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