Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ju...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    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
johnt75's avatar
johnt75
Super User
3 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

    Of course... thanks!