Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dynamic Title - Multiple Selections

Here's my current formula:    Selected Zone = var selectedcolor = SELECTEDVALUE('All Data'[Zone]) return "Zone: "& IF(ISBLANK(selectedcolor), "All", selectedcolor)    However, when I select more ...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    You may try to use below measure. Here is the reference for you.

    Selected Zone =
VAR selectedcolor =
    VALUES ( 'All Data'[Zone] )
RETURN
    "Zone: "
        & IF (
            COUNTROWS ( selectedcolor ) = COUNTROWS ( ALL ( 'All Data'[Zone] ) ),
            "All",
            CONCATENATEX ( VALUES ( 'All Data'[Zone] ), 'All Data'[Zone], "," )
        )

    Regards,

    Cherie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks v-cherch-msft. This works for the most part.

 

However, when all my zones are selected it displays every single name. Can we get it to just say "All" when I have all my zones selected? This would be my default view.

 

EDIT: Nevermind v-cherch-msft. I've got it working now.

 

 

KarenF's avatar
KarenF
New Member
7 years ago

Hi Anonymous

 

Can you please share your fix with me. I'm struggling to get mine to work when all are selected. Like you, when I slected all, the title listed everything instead of saying 'All Selected'. However it works great when selecting individual ones. So if 3 name selected it shows those 3 names

 

Many thanks

Karen

  • KarenF's avatar
    KarenF
    New Member
    7 years ago

    Think ive resolved it

     

    Test Title For Dynamic Contractor Title v2 =

    VAR SelectedContractors =

       VALUES (Contractor[Contractor_Name])

    RETURN

        "Contractor/s: "

     

    &  IF(NOT(ISFILTERED(Contractor[Contractor_Name])),"All Contractors" , IF( ISFILTERED(Contractor[Contractor_Name]), CONCATENATEX ( VALUES (Contractor[Contractor_Name]), Contractor[Contractor_Name], "," )))