Forum Discussion
Items by Location
Hey santi17 .
To recreate what you're trying to do, I did the following.Then I connected them both over ETag on the Model Page.
Then I created a Slicer Visual:
Then I created an ArcGIS Map Visual:
Location: Country, Size: Count of ETag (you can put inventory and maybe put the sum of aggregation)
Then I checked the visual:See the dots on India, China, & Pakistan, now Hower over the country for the counts.
This seems like what you're trying to achieve.
Reply for further queries and Mark it as the answer If this solves your query.Thanks
Hello santi17 ,
these two tables both connect to salesInvoices table, so when you show sales by location and by item the data will show correct.
Most of the times they don't need to be connected directly, because both are dimension tables.
check the concept of starschema modeling to understand more about what's happening
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi Idrisshatila,
To make it clear.
I have fews location.
I just want to know how many left Items Z, like its will show in Location Z = 5, Location X = 9 etc.
Everytime we change value in slicer (items), the location will show Location and Sum of Inventory
It's possible?