Forum Discussion

heatherkw's avatar
heatherkw
Icon for Helper I rankHelper I
3 years ago
Solved

Dynamic Text Using List Separated by Commas and or Before Last Value

Hello, A long timeago I found something that provided the solution I'm looking for, but I can't seem to find it again. I have a slicer for program type and users can select 1-5 values.   I am usin...
Need Help
  • heatherkw's avatar
    heatherkw
    3 years ago

    Thanks! This helped lead me down the right path. I still had to do some tweaking, but this works for me based on how it's set up in my dashboard.

     

    ProjectSelection_Exits = 
VAR SelectedProj = VALUES(ExitsPH_HUD[RecodePgmType])
VAR NumberOfSelectedProj = COUNTROWS (SelectedProj)
VAR AllButLastProj = TOPN(NumberOfSelectedProj - 1, SelectedProj)
VAR LastSelectedProj = EXCEPT(SelectedProj, AllButLastProj)
RETURN
IF(NumberOfSelectedProj = 3 || NumberOfSelectedProj = 4, CONCATENATEX(AllButLastProj, ExitsPH_HUD[RecodePgmType], ", ") & ", or " & LastSelectedProj, 
IF(NumberOfSelectedProj = 2, CONCATENATEX(AllButLastProj, ExitsPH_HUD[RecodePgmType], ", ") & " or " & LastSelectedProj, 
IF(NumberOfSelectedProj = 1, LastSelectedProj, "all service types")))

     

     

Sergii24's avatar
Sergii24
Icon for Super User rankSuper User
3 years ago

Hi heatherkw, here is the way to create a measure that dynamically contains multiple selected string values:

 

 

 

 

Dynamic Title Measure = CONCATENATEX( Projects, Projects[Project Title], "," )

 

 

 

 

Original solution has been proposed by Matt Allington in this community post.

 

Sergii24's avatar
Sergii24
Icon for Super User rankSuper User
3 years ago

heatherkw, here is a modification for another text when more than 3 projects are selected:

 

 

Dynamic Title Measure = 
    IF(
        COUNTROWS( Projects ) > 3,
        "More than 3 projects selected",
        CONCATENATEX( Projects, Projects[Project Title], "," )
    )

 

 

Good luck! 🙂