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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
b244293
Frequent Visitor

Dynamically changing the Legend in Bing map Power BI

Hi,

I have created the table named  "dummyperson" as shown below,

NameLatitudeLongitudeisEligibleisActive
A44.57-73.52EligibleActive
B44.57-73.52EligibleActive
C44.57-73.52EligibleActive
D44.57-73.52EligibleActive
E44.57-73.52InEligibleInactive
F44.57-73.52InEligibleInactive
G42.22-87.99EligibleActive
H42.22-87.99InEligibleActive
I42.22-87.99InEligibleInactive

 

Based on the table I can create the map view (isEligible & isActive) as shown below,

m1.png

 

But, Here, I need a single map. when selecting on the slicer control the map legend should be changed. the slicer table is below,

 

m2.png

 

I need the report as shown below,

 

m3.png

 

The intension of the report is based on the slicer selection, the bing map should be changed. Can you help me how to change the measure value on "Legend" property dynamically ?. 

 

Thanks,

Bala.

 

 

 

 

1 REPLY 1
VSrujana
Frequent Visitor

You can unpivot the columns IsActive and IsEligible . Once done , please use the attribute column in the slicer and value in the legend of the map. Remove the title of the legend in Map and instead you can create a dynamic title to describe the visual i.e , Count by IsActive or Count by IsEligible

NameAttributeValue
AIsEligibleEligible
AIsEligibleInEligible
BIsActiveActive
BIsActiveInActive

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.