Power BI Map

[sherlingiftyM]

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

Leads_Map_MTD =

'Lead Master'[State Name] & UNICHAR(10) &

FORMAT(

    CALCULATE(

        [Leads MTD],  // Assuming [Leads MTD] is a valid measure that calculates leads for the current month

        ALLEXCEPT('Lead Master', 'Lead Master'[State Name])

    ),

    "#,0"

)

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---?

[SamWiseOwl · Accepted solution]

Hi @sherlingiftyM 

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

[sherlingiftyM]

1. I need India Map visual  - which Map visual is suitable for it
2. Map visual with category Labels & Values 

[SamWiseOwl · Accepted solution]

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!

[sherlingiftyM]

Thnak you..... for your reply

[SamWiseOwl · Accepted solution]

Hi @sherlingiftyM 

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