Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi community,
I have a report of Vacancy Fulfillment, my raw data is in excel, and one of the fields is Country. The problem is, that the countrys are in acronym. For example AR for Argentina, BO for Bolivia, CL for Chile, EC for Ecuador, PE for Peru, PY for Paraguay and UY for Uruguay some examples.
I want to show the Vacancy Fulfillment KPI that i already calculated with a measure for each country in the map.
The raw data report brings the information with the acronym, and it would be awesome not to change them manually, is there a way to create a command for PowerBI to recognize the acronyms for each country in the map? Never used the map visualization before.
Thanks & Regards!
When using Map visual, try to use three-letter abbreviation instead of two-letter abbreviation to make sure the country or region can be recogized properly. I suggest you associate your two-letter country/region abbreviations with three-letter country/region abbreviations. For more details, please see:
Tips and Tricks for Power BI Map visualizations
How-To: Display 2-letter country data on a Power BI map
Regards,
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
108 | |
108 | |
93 | |
61 |
User | Count |
---|---|
169 | |
138 | |
135 | |
102 | |
86 |