Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good day
I am sure that this is simpler than I am finding but I am having troupble even starting how to build a GEO map. I have attached my example pbix.
I have also brought in to the pbix an excel file with longs and lats etc. However after joining that table to my CONSOL INBOUND table I just don't seem to get anything to work.
https://drive.google.com/open?id=1B2fJlLUbRSNLZJbnbC72gNpT2Gt2unz3
The fields in the Consol Inbound table I would be using are the:
1. First Leg Load Country
2. First Leg Load Port
I have really tried everything over many hours .. so please could you assist by showing me the basic steps to build?
thanks so much,
regards,
Marc
Solved! Go to Solution.
There is in fact same data between iso5 and First leg Load .. both show 5 alpha characters so surely the link is valid?
thanks
Marc
Hey @MarcUrdang,
you need to categorize your longitude and latitude columns correctly.
After that you should remove the columns from your visual and put them in again.
Also I think that your slicer settings where "to restrictive". I don't know your data but please check them to 🙂
If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others
Have a nice day!
BR,
Josef
Graz - Austria
Good morning
Thanks but I just neglected to keep settings .. I had already tried that. All the data is within the parameters of the filters. Any othe ideas?
https://drive.google.com/open?id=1TgXH4q2UA4fET6TSsmw5GAm2JMDg6Qso
thanks Marc
Hi @MarcUrdang,
In your model, the relationship is established based on Consol INBOUND[First Leg Load] and Sheet1[iso 5], However, there is no same value between them. So you can get nothing in your visual.
There is in fact same data between iso5 and First leg Load .. both show 5 alpha characters so surely the link is valid?
thanks
Marc