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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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