Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two maps that are on the same tab. They both have same Customers across the country with exact same Lat and long from the same source.
I noticed this morning that when I click on one bubble in one map, it doesn't pick up the same customer on the other map. It would pick up some other customer in some other geographic area?
what could be the reason?
Hi @salman_ali
Thanks for reaching out to us.
Not sure what you put in the Map visual and what's the relationship between the tables. Did you notice this morning? Was it working fine before?
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
how is your data related? its mostly likely to do with how you have set up your model, the relationships between the tables, can you share?
Proud to be a Super User!
I looked at the relationship. It seems fine. Each of the two maps have two tables that are both joined by Customer number. Lat and long are coming from only one of these two table in each map.
So it makes no sense to me
it seems fine but if you post the screen shot of the relationship i am very sure i will find the likely cultprit.
Proud to be a Super User!
Sure
also lat and long are coming from
what measures are you using on each map? what sort of information are you trying to show. bi directional relationships can be dangerous and can return ambigious results. You are joining on location, not on customer so this relationship between the tables will not guarantee consistent results. Ideally a star schema model is always best, which is your categorical data in look up tables and the transactional data holds foreign keys from each look up table.
if you explain what you trying to show on each map and what table it is coming from, then it will give me an idea of how to model this data.
if you able to share the data in text format that would be more ideal.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
106 | |
104 | |
89 | |
65 |