How to show the selected levels of the hierachical slicer in the title of the visualisation

[MarcoDekker]

Hi all,

I have a hierarchical slicer to allow the user to select the sales from whatever geographical region he/she needs.
All levels are populates using one table with the various attributes.
So they can select nothing at all, 1 or more countries, 1 or more states or one or more cities.
The user wants to have the selection as the title of the visualization

I tried to create this sophisticated dax but can not handle it well.
When a user selects 1 or more cities: the title should be: 'Your selection consists of' and then the selected cities
When a user selects 1 or more States: the title should be: 'Your selection consists of' and then the selected states
When a user selects 1 or more Countries: the title should be: 'Your selection consists of' and then the selected countries

How to get this done? I read the trick of putting the measure into the title. I 'just' need to create this measure..

[Bifinity_75 · Accepted solution]

Hi @MarcoDekker , try this measure:

Selection = if(ISFILTERED('Table'[City]),"Your selection consists of " & CONCATENATEX(VALUES('Table'[City]),'Table'[City],", "),
                if(ISFILTERED('Table'[State]),"Your selection consists of " & CONCATENATEX(VALUES('Table'[State]),'Table'[State],", "),
                    if(ISFILTERED('Table'[Country]),"Your selection consists of " & CONCATENATEX(VALUES('Table'[Country]),'Table'[Country],", ")
            )
                )
                    )

Best regards

[MarcoDekker]

Thanks, @Bifinity_75 . Works great. Once a statement works, dax seems so straightforward, but to get there..

[lbendlin]

Read about ISINSCOPE()