How to add the store information of bubble on Map

[ADSL]

Dear BI Community Team,

I have been loading the customer location into the map and create the relationship of Sales Order, Store Visit, Sales Rep, Calendar.

There are some information missing when we are move the cursor on bubble ---- Customer Code/Name, Total Sales.

Sample Pbix - https://drive.google.com/file/d/1wQd3avNL2GFZMQWl3Tlr9lMJkwo4zODp/view?usp=sharing 

Any suggestion to add these kind of information on bubble?

Thanks and Regards,

[negi007 · Accepted solution]

@ADSL have corrected the relationship in the file. it is working fine now. 

[negi007]

@ADSL you can add additional fields in the tooltip section. it will show values for those fields when you move your mouse over the bubble.

[ADSL]

Hi @negi007 ,

Any suggestion of store Total sales? We also want to know the total sales of store purchased.

Thanks and Regards,

[negi007]

@ADSL due to some restrictions i can't download the file in my system. however, you can drag the total sales value field to tooltip section and it will display that value as well. see the below example.

[ADSL]

Hi @negi007 ,

Please kindly try to access again for sample pbix file - https://drive.google.com/drive/folders/1ttgcLkIh8ZuL7oKbMHATH6Xz6YsAEWqf?usp=sharing 

I already add the total sales to Tooltip but still cannot see it.

Thanks and Regards,

[negi007]

@ADSL when you remove all the filtes from the month slicer, you will be able to view the sales data on the bubble. there is some mismatch in the date relationship which causing the issue.

[ADSL]

Hi @negi007 ,

1. Could you please help to correc it for relationship?

2. Please help to correct the total sales by customer not sales rep.

Thanks and Regards,