Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a column called Country (US,IN) with 2 letter country code and what I need is another column that has country name in it. I prefer Powerbi inbuilt functionality rather than downloading a new mapping code to name file from open source.
Solved! Go to Solution.
Hi @utsavpatel ,
There is no in-built functionality in Power BI that by-default creates a column with country name for you against these country codes.
Also, what you are trying to achieve with this country code and country name in Power BI will help in understanding what a proper solution could be.
For example, if you want to create a map visual, then Power BI does recognises country codes on it. But still more details on this will be helpful.
Thanks,
Pragati
So I just opened the raw data file in excel and changed the country code column to a geography data type and inserted a new column that referenced the country code column then just put .name example =B2.Name. Then just copied and pasted the values and changed the country code column back to a text field and saved and closed. Then you could just use that as another data source.
Hi @utsavpatel ,
There is no in-built functionality in Power BI that by-default creates a column with country name for you against these country codes.
Also, what you are trying to achieve with this country code and country name in Power BI will help in understanding what a proper solution could be.
For example, if you want to create a map visual, then Power BI does recognises country codes on it. But still more details on this will be helpful.
Thanks,
Pragati
@utsavpatel , I doubt such functionality. You might have get some code descirption data and merge it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |