Forum Discussion
Power BI Map
In Power BI Map Visual - i need Map value along with category name
they ask me to use calculated column as static as this way
i created this & got answer along with category name, but the value of MTD values availble only for current month...While chosing Filter by Previous month Sep 2024 ,the MTD values not shown - it shows only current month value since calcualted column is static---?
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!
4 Replies
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
Thnak you..... for your reply
1. I need India Map visual - which Map visual is suitable for it
2. Map visual with category Labels & ValuesDepending 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!
