Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have one Location filter at the top and a bing map. I have cities list. If I select any cities from the filter, the map shows that city. Now I want to set 3 default cities in the map. I used filter in the map it showed 3 cities on the map but filter control stopped working.
City
Austin |
Dallas |
New York |
Akron |
From the above table I want to set Austin, New York and Dallas as default city in the map. And, when I select the city from the drop down the map should show that city:
Please help me with the above scenario.
@mudgalbk
I guess this is not supported, you can only create a measure to show default cities, but measures cannot be used on the map location field. And as far as I know, there is no other custom map visuals that can set measures as locations.
The only possibility is to create the measures to show the Long and Lat values but this can be complex and might not be feasible depending on your model. And as far as I know, there is no other custom map visuals that support setting measures as locations.
Paul Zheng _ Community Support Team
Thank you for the reply. I do not have any values in my table whereas you used sum in the measure above. it's all text values.
@mudgalbk , Best is that you save 3 cities in the slicer.
The second is to have an independent table for city and have slicer on that and use a measure like
calculate(sum(Table[Value]), filter(Table, Table[city] in {"Austin", "New York", "Dallas"} || Table[City] in values(City[City])))
Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |