Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ADSL
Post Prodigy
Post Prodigy

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
Community Champion
Community Champion

@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
Community Champion
Community Champion

@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
Community Champion
Community Champion

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

negi007
Community Champion
Community Champion

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

negi007
Community Champion
Community Champion

@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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.