Creating a Map Visual with 2 different tables with same headings

[Anonymous]

Hi,

I like to create a map visual showing the competitive landscape but I have data from 2 different tables with same headings. Is it possible? Sample tables are shown below. Or do I have to combine into a single table before I can create a visual?

Table 1

Vendor	Postal Code	No of Visitors
MacDonald	Singapore 011228	100
MacDonald	Singapore 022556	200

Table 2

Vendor	Postal Code	No of Visitors
KFC	Singapore 011229	120
KFC	Singapore 022558	80

Thanks

[amitchandak · Accepted solution]

@Anonymous , merge in power query, rename column before merging

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

or create common dimension like vendor and post code and join with both tables and use those in visuals

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

Try to create star schema

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/