Forum Discussion
Heat Map Visual Troubleshooting
Hi, I am trying to display sales by post code in the UK but I have the following issues: 1. Some cities are showing in the USA where there are the same name as the UK 2. When I drill down to...
Hi Anonymous
Please download this PBIX file with sample data and a map
Taking your sample data and importing to PBI, I set the City, Post Code and Country columns to the correct Data Category
Then adding a map visual I added these values
Which gave me this map
Regards
Phil
Hi Anonymous
Can you please share some sample dataso Ican get an idea of how you have it set up.
The columns need to be assigned specific data categories like Place, City, Country, Post Code etc and sometimes you need to create another column with the place,post code joined together before the map recognises it properly.
Regards
Phil