Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |