Items by Location

[santi17]

Hi there,

I want filter items by location,

I just load the "items" table & "location" table.

But I don't know how to make them connect in Power BI.

Any body happen have try to combine Items by Location?

[JaySharma · Accepted solution]

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

[Idrissshatila]

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 👍

Follow me on Linkedin

[santi17]

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?