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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
I have created the table named "dummyperson" as shown below,
| Name | Latitude | Longitude | isEligible | isActive |
| A | 44.57 | -73.52 | Eligible | Active |
| B | 44.57 | -73.52 | Eligible | Active |
| C | 44.57 | -73.52 | Eligible | Active |
| D | 44.57 | -73.52 | Eligible | Active |
| E | 44.57 | -73.52 | InEligible | Inactive |
| F | 44.57 | -73.52 | InEligible | Inactive |
| G | 42.22 | -87.99 | Eligible | Active |
| H | 42.22 | -87.99 | InEligible | Active |
| I | 42.22 | -87.99 | InEligible | Inactive |
Based on the table I can create the map view (isEligible & isActive) as shown below,
But, Here, I need a single map. when selecting on the slicer control the map legend should be changed. the slicer table is below,
I need the report as shown below,
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.
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
| Name | Attribute | Value |
| A | IsEligible | Eligible |
| A | IsEligible | InEligible |
| B | IsActive | Active |
| B | IsActive | InActive |
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 13 | |
| 8 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 29 | |
| 18 | |
| 17 | |
| 11 | |
| 10 |