Hello community, I'd like to get the selected filter (in my case these are cities) as a title on my dashboard. This measure works fine, when nothing or ONE option is selected, but I also want to get a sensful title if more then on option (two or more cities) ist selected. At least one statement like "More than one Town", at best the list of the selected cities.
1 City Filter title =
2 VAR SelectedSite = SELECTEDVALUE(IdeaCities[City])
Hi @Tober1996 , Try this: Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too. Nathaniel
City Filter title =
VAR _Selected =
SELECTEDVALUE ( myTable[Cities] )
ISBLANK ( _Selected ),
"Choose one city from this list "
& CONCATENATEX ( VALUES ( myTable ), myTable[Cities], ", " ),
Did I answer your question? Mark my post as a solution!
Hello Nathaniel, that is nearly perfect, but it should not be a request for selection, but a note/title (in a card) what is selected.
With your measure -if nothing was selected- every cities are displayed. The solution should be: - nothing selected: "Selected: All cities" - London selected: "Selected: London" - London and Paris and Rome selected: "Selected: London, Paris, Rome"