Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Tober1996
Helper I
Helper I

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 

1 ACCEPTED SOLUTION

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Nathaniel_C
Super User
Super User

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
    )

 




city1.PNG

 

city.PNG

 

 

city12.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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?

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.