Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 |
---|---|
20 | |
14 | |
11 | |
8 | |
6 |
User | Count |
---|---|
23 | |
23 | |
20 | |
15 | |
10 |