cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ADSL
Post Partisan
Post Partisan

How to add the store information of bubble on Map

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?

 

2022-11-09_12-34-17.png

Thanks and Regards,

1 ACCEPTED SOLUTION
negi007
Super User
Super User

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




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

View solution in original post

7 REPLIES 7
negi007
Super User
Super User

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




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

negi007
Super User
Super User

@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.

negi007_0-1667977354360.png

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Hi @negi007 ,

 

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

 

Thanks and Regards,

@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.

negi007_0-1667980986654.png

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

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,

@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.

 

negi007_0-1667992359816.png

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

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,

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors