Forum Discussion
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 it possible to do this automaticly within Power BI
Regards
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.
3 Replies
- nandukrishnavs
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 🙂 - DataVitalizer
Super User
Hi Reimer
You can change the data type within powerbi
Does it work ? Mark it as a solution
A kudos would be appreciated 🙂
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.
