Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi All,
I have lat and Long for the stores and store names and territory of each stores.
I have added the store name in the legend and lat and long of the store. I want to know if the color of the stores can be shown as per the territory. Right now it shows different color for different stores. If the group of stores are under one territory, they should all show green(for eg)
Thanks for your help in advance,
Bhavya
Solved! Go to Solution.
I was thinking log lat are from the store ? You drag store to the tooltip. Not tried but their location field also
You have dragged Store under legend that is why store wise color. Long lat might already be giving you store-level data. So Drag territory to Legend.
Thanks for the reply. I have added store, because i want to see all the stores. If i add Territory in legend, how can I see the stores in that territory?
Yes it worked. Thank You
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 18 | |
| 18 | |
| 15 |
| User | Count |
|---|---|
| 51 | |
| 44 | |
| 43 | |
| 39 | |
| 32 |