Forum Discussion

Tober1996's avatar
Tober1996
Helper I
6 years ago
Solved

Filtered Options as dynamic title

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])
3 RETURN
4 IF(ISBLANK(SelectedSite);
5 "All";
6 SelectedSite)

---------------------------------

Thanks for help 

  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hello Tober1996 ,
    Based on the above logic, there is a simpler way.

    Selected City Name = IF(ISFILTERED(myTable[Cities]), "Selected: " & CONCATENATEX(VALUES(myTable),myTable[Cities],", "),"Selected: All cities ")

     
    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

3 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    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] )
RETURN
    IF (
        ISBLANK ( _Selected ),
        "Choose one city from this list "
            & CONCATENATEX ( VALUES ( myTable ), myTable[Cities], ", " ),
        _Selected
    )

     




     

     

     

     

    • Tober1996's avatar
      Tober1996
      Helper I
      6 years ago

      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"

      Can you modify the measure to this function?

      • Nathaniel_C's avatar
        Nathaniel_C
        Community Champion
        6 years ago

        Hello Tober1996 ,
        Based on the above logic, there is a simpler way.

        Selected City Name = IF(ISFILTERED(myTable[Cities]), "Selected: " & CONCATENATEX(VALUES(myTable),myTable[Cities],", "),"Selected: All cities ")

         
        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