Forum Discussion
Reimer
Helper II
Helper IITransforming cities into provinces
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 i...
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.
nandukrishnavs
Community Champion
Community Champion
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 🙂