In this informative video, Mitchell Pearson demonstrates a highly requested but technically unsupported feature in Power BI: adding data labels to maps. Although Power BI does not natively support this functionality, Pearson shares a clever workaround using latitude and longitude data.
Why Add Data Labels to Power BI Maps?
Adding data labels to maps in Power BI can significantly enhance the readability and usefulness of the visual representation of geographic data. Although this feature is not natively supported, many users have requested this functionality, and Pearson’s tutorial offers a solution. His previous blog and video on this topic received high engagement, prompting him to revisit the subject using the updated Power BI interface on the Pragmatic Works channel.
Steps to Adding Data Labels Using Latitude and Longitude
The key to this trick is utilizing the latitude and longitude capabilities within Power BI. Here’s how to add data labels to your Power BI map:
- Get Latitude and Longitude Data: Begin by obtaining a dataset containing the latitude and longitude for each state (or city, if more specific data is needed). Pearson found a public webpage listing latitudes and longitudes for U.S. states and used it as a source.
- Merge the Data: Use Power Query Editor to clean and merge this data with your existing geography dimension table. This will allow you to map the data points to specific locations on your map visual.
- Create a Calculated Column: Once your data is prepared, you’ll need to create a new calculated column in Power BI. This column will concatenate the state name with the corresponding sales data, creating a custom label. Pearson shows how to write a DAX formula to sum sales for each state and format the result.
- Map Latitude and Longitude: Replace the default state data on your map visual with the latitude and longitude values from the geography dimension. This step ensures that your map is correctly configured to display data points at the right geographical locations.
- Add the Data Labels: To display the calculated labels on your map, go to the formatting options and enable category labels. This will show the concatenated state and sales data directly on the map.
Limitations of the Workaround
While this workaround can be effective, Pearson highlights some important limitations:
- Static Data: Since the calculated column is static, it does not dynamically update when filters are applied in the report. For example, if a user selects a specific year, the sales data in the label will not adjust accordingly, unlike measures which are evaluated at runtime.
- Limited Drill-down Options: The current method is not suitable for detailed drill-downs, such as drilling into cities within a state. To achieve that, additional latitude and longitude data would be required for each city, and separate map visuals with bookmarks might be necessary to toggle between state and city views.
Conclusion
While Power BI doesn’t natively support adding data labels to maps, Mitchell Pearson’s workaround allows users to creatively display these labels using latitude and longitude data. Though there are some limitations with static data and drill-down options, this method can be highly effective for specific use cases. If you want to learn more about Power BI, including advanced techniques, be sure to check out Pragmatic Works' Power BI boot camps.
Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power BI and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.