Forum Discussion
Power BI Map
What is your question?
You are correct in what you say, calculated columns only recalculate when the data is refreshed.
They can't be dynamic based on a measure.
If there are limited number of options (This month, last month, same month last year) you could create each of these as a seperate calculated column. Then use a measure to switch which value is being shown in the map.
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Depending on what your company has set to allow: Globe or Azure.
If you have specific areas you want to look at the filled map can also work.
The advantage of the Azure map being it has additional features like Reference layers, Tile layer, cluster maps and 3d modelling.
You can use Latitue and longtitude on any of them.
Geocoding with post codes can be a bit spotty depending on the country/area.
One other thing to consider is Globe and filled maps using Bing.
Azure uses TomTom.
Hope this helps!
Thnak you..... for your reply