Forum Discussion
Filtered Options as dynamic title
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
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
)
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