How to add Data Labels to Maps in Power BI! Tips and Tricks

In this video we take a look at a cool trick on how you can add a data label to a map in Power BI! We use a little DAX here to create a calculated column and we use a few functions like CALCULATE, ALLEXCEPT and FORMAT.

#MitchellPearson #MitchellSQL #PragmaticWorks

[fabiannickfotografie]

How come PBI is still so popular whilst missing such basic features like labeling?! But thanks for the workaround ;)

[sammjay]

I've been using the Tooltips feature to create data labels. So far, they only appear when you hover but it's a much simpler option for someone who may have some difficulty with formulas

[robertjameshernandez]

Very Omg i was racking my brain and could not figure it out. I'm coming from mapping in Tableau which has data labels.

[HamzaGM-zy]

Hello Again, i had the same issue, your method worked with me very well, but there was another issue, the filters didnt work with the map, for example i have 100$ sales in morocco, the 100$ did not change if i filter by departement or projects could you help ?

[padynz]

Very useful video presented with excellent clarity. Really appreciate your effort.

[abdisetarjamae]

Thank you for the useful video. Can data labels be added using either Shape Map or Mapbox in Power BI?

[thierrythomas]

Thank you Mitchell for this very interesting video,
I have a question about the aggregation.
In my report, I have a slicer for the transaction type and it works well : it makes the right sum of the values for the chosen type.
But, when I introduce a slicer date, it doesn't work : in fact, when I have only a value in the values column, it's ok (one value for one month). For example, for France, if I have one transaction type, one month, I have the right value. But, if I select two months, I have two values in the labels (because I have two values in the values column, one by month). It doesn't make the sum of the two values.
Obviously, if I don't select any month, I have the same problem.
Any idea to fix it ?
Thierry

[mikedbman]

This works like a charm. Thanks for the solution!

[gogax]

I have a question Mitchell, how do you connect the Sales by State data with slicer (for example: Year slicer)

[perovano]

Thank you Mitchell! That's was a very good one!

By the way, I have a question:

I created the table, like you did, with the name Geography and the relationship was made with my table.

Now, I'm tryng to create a filter, with the information that I have in my table, for example, Client Name.

If I insert the variable Client Name oh the visutal of the map, and select a random client, the filter dosent works.

Do you know what to do?

[alhadibujang]

Thank you. I haven't used PowerBI before. May I know, is it possible to do conditional formatting on the data labels on the map. For example, if total sales < 100, the data label colour is red.

[cristianmadrigal]

Dear Mitchell! Loved the video, it worked out pretty well, and it was so easy to understand and replicate. Thanks.

[HamzaGM-zy]

i have a question, how can lock the zoom level after finishing the work on the map ? i mean i want to show just a part of the map, the idea is when i finish setting the map, i want to zoom in a part of it and after that fixing this zoom to not be modified, to always focusing on one part of the map, could you help ?

[shoeb]

Thanks for the trick but this map is not getting filtered nor interacted with other available dropdown filter

[Aeeess]

Thank a lot Mitchell😊 I follow your tip and the result is great but when I need to change or filter year like 2023 or just 2024 it doesn't change follow, it's still show total calculate (2023 + 2024). And anyone know how to fix it? Thank you ✌️🏻

[michelcesar]

This is amazing! Very creative solution! Greetings from Brazil!

[evanlemay]

Is there a way to do this on a filled map or ArcGIS map? I'm trying to show a data label (that's already a column in my excel) over the middle of a census region (already added lat/long for middle of each census region). I can get this map, and I can separately get a filled map, but can't find a way to do both. This took 5 seconds to do in Tableau not sure why it's not an automatic option in Power BI

[chriscrowe]

Awesome thanks! I used this theory to simply add a percentage of sales (ie: '12.6%' only) category label without the bulky state name label/text.

[TungProBoy]

I found out that if you create the calculated collum as you did and just chuck that into location, Power BI would recognize the location (it works for me). So basically skipping the longitude and latitude part.

[ruthlammers]

Hey, Mitch...this is great. Question: How can I do this and allow the user to filter results on the needed date range? Is this possible?