Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi
I have a map visual in my report that displays different cities. What I want to do is:
When I click/select a city in the map visual,
A card visual should dynamically display the name of the selected city.
I assume I need to use a DAX measure for this, but I'm not sure how to get the selected value properly when one city is selected.
My Questions:
What DAX formula can I use to display the selected city in a card?
How can I handle cases where no city is selected or multiple cities are selected?
Is there a better way to achieve this?
Solved! Go to Solution.
Hay @Tamilarasan_ thanks for asking question.
You can easily achieve this by using this Dax
Selected City =
IF(
ISFILTERED('YourTable'[City]),
SELECTEDVALUE('YourTable'[City], "Multiple Cities Selected"),
"No City Selected"
)
Output: As you can see when i select City Dhaka it shows in "Dhaka" in the card.
Without any selection:
Sample FIile Download from here: https://limewire.com/d/ccvit#HiEeYHNF35
Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
Hay @Tamilarasan_ thanks for asking question.
You can easily achieve this by using this Dax
Selected City =
IF(
ISFILTERED('YourTable'[City]),
SELECTEDVALUE('YourTable'[City], "Multiple Cities Selected"),
"No City Selected"
)
Output: As you can see when i select City Dhaka it shows in "Dhaka" in the card.
Without any selection:
Sample FIile Download from here: https://limewire.com/d/ccvit#HiEeYHNF35
Did it work? ✔ Give a Kudo • Mark as Solution – help others too!