Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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 👍
Proud to be a Super User! | |
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |