Dynamically changing the Legend in Bing map Power BI

b244293 — Thu, 14 May 2020 12:12:06 GMT

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.

Re: Dynamically changing the Legend in Bing map Power BI

VSrujana — Thu, 14 May 2020 21:09:19 GMT

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

topic Re: Dynamically changing the Legend in Bing map Power BI in DAX Commands and Tips

Dynamically changing the Legend in Bing map Power BI

Re: Dynamically changing the Legend in Bing map Power BI