Data Label on Map

[Anonymous]

Hi, I need help here to solve this issue that I'm facing on to display data label on map with combination Country & Calculated field which is to show latest month count.

The formula is like this:

Country - Facility ID = 'Facility'[Country] &"-"& CALCULATE([CountD Facility ID 2],

FILTER( ALL(DateSelector[YearMonth]),

DateSelector[YearMonth] = DATE(YEAR(MAX(DateSelector[YearMonth])),MONTH(MAX(DateSelector[YearMonth])),DAY(DateSelector[YearMonth]))))

But the data label show only country like this:

However, when i create separate measure to have the latest month value and put in tooltip, the tooltip works as it shows the latest value. 

And does anyone know that if possible i can have the data label on Filled Map?

Thank you in advance! 🙂

[v-yulgu-msft]

Hi @Anonymous,

Please modify above formula to:

Country - Facility ID =
'Facility'[Country] & "-"
    & CALCULATE (
        [CountD Facility ID 2],
        FILTER (
            ALLSELECTED ( DateSelector ),
            DateSelector[YearMonth]
                = CALCULATE ( MAX ( DateSelector[YearMonth] ), ALLSELECTED ( DateSelector ) )
        )
    )

Best regards,

Yuliana Gu

[Anonymous]

Thanks for the reply! But still the map just showing country and dash, not the calculation. I did test your formula and it works only in tooltip the same with what I have now.

[v-yulgu-msft]

Hi @Anonymous,

In my test, the data label could show combination values correctly on Map visual. Please update your Power BI desktop to the latest version for a test. If problem persists, please share your sample .pbix file so that I can check for you. Do mask the sensitive data before uploading, just share with the dummy data.

Best regards,

Yuliana Gu

[Anonymous]

Here is the link to sample workbook: link

Thanks.

Regards,

ssaz

[parry2k]

@Anonymous I dont think you can do this, as soon as you add the value to the country, data category for your calculated field will change to non-geographic and you will not able to plot the values on the map.

Only solution I can think of is create a measure and add use that measure as tooltip 

[Anonymous]

Can you share your sample workbook?

Highly Appreciated 🙂