How to categorize state pin and city in power bi Address

Question

How to categorize state, pin and city in power bi from block Address?

Answer 1

After loading dataset, you can split in the query editor.

If the address consists of full address in one field,

1. Go to Query editor.

2. Click on the address field and Click on split by and select delimiter as "," and click ok.

But before splitting see to that all address are in a similar format to split into country/city/state/pin.etc

3. Then the full address would be split as per commas.

4. Edit the split columns as per use.

If you are interested in learning Power BI, check out Power BI Curriculum now!

Comments

This is from Query Editor. my question is from Data.

---

Hey, @abdul,