Dynamic Title - Multiple Selections

[Jodes]

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 than one zone, it appears as "All". Here is a picture:

https://imgur.com/a/OgNquhP

My question is, how can I get it to display the text of what I'm selecting?

[v-cherch-msft · Accepted solution]

Hi @Jodes

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

[Jodes]

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]

Hi @Jodes

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]

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], "," )))