Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.
---------------------------------
Thanks for help
Solved! Go to 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
Proud to be a 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
)
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
Proud to be a Super User!
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
8 | |
7 |