Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi all,
Can somebody help me please. I am a starter at Power BI and I am looking for a way to transform Dutch cities into Dutch provinces.
Do I have to add a column to the excell file or is it possible to do this automaticly within Power BI
Regards
Solved! Go to Solution.
@Reimer
You cannot change Cities to Provinces, because Power Bi is not that kind of automate software to read your city and assign it to a province. You need manually enter the Province column and set it as Province data type.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Reimer
You cannot change Cities to Provinces, because Power Bi is not that kind of automate software to read your city and assign it to a province. You need manually enter the Province column and set it as Province data type.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Reimer
You can change the data type within powerbi
Does it work ? Mark it as a solution
A kudos would be appreciated 🙂
Power BI can't convert the city to provinces automatically. You have to add another column to mention the provinces.
Then you can set the data category as state or provinces.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
87 | |
71 | |
63 | |
60 |