https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Inventory-amounts-shown-on-Map/m-p/3164354#M7243 <P>Hello!</P><P>&nbsp;</P><P>I am trying to build an inventory map where a person can enter a SKU into a search feild, then bubbles will appear over locations on the USA map where the inventory is located. I also would like the size of the bubble to reflect the amount of inventory compared to other locations.&nbsp;</P><P>&nbsp;</P><P>-Straight forward data I have is warehouse zip codes (gets me the position of the bubbles on the map)</P><P>-Each warehouse has a unique name&nbsp;</P><P>-I have a general ledger that is updated live, that shows SKU, WAREHOUSE, QTY.</P><P>&nbsp;</P><P>I need help in how to filter the data for the map as the user changes the sku.&nbsp; I am guessing I would need count functions that count QTY per WAREHOUSE which gives the value for the bubble size......but would need this to work with ALL SKUS and filtered SKUS.</P><P>&nbsp;</P><P>Any help would be appreciated!</P> Thu, 30 Mar 2023 21:42:07 GMT srlozier 2023-03-30T21:42:07Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Inventory-amounts-shown-on-Map/m-p/3164354#M7243 <P>Hello!</P><P>&nbsp;</P><P>I am trying to build an inventory map where a person can enter a SKU into a search feild, then bubbles will appear over locations on the USA map where the inventory is located. I also would like the size of the bubble to reflect the amount of inventory compared to other locations.&nbsp;</P><P>&nbsp;</P><P>-Straight forward data I have is warehouse zip codes (gets me the position of the bubbles on the map)</P><P>-Each warehouse has a unique name&nbsp;</P><P>-I have a general ledger that is updated live, that shows SKU, WAREHOUSE, QTY.</P><P>&nbsp;</P><P>I need help in how to filter the data for the map as the user changes the sku.&nbsp; I am guessing I would need count functions that count QTY per WAREHOUSE which gives the value for the bubble size......but would need this to work with ALL SKUS and filtered SKUS.</P><P>&nbsp;</P><P>Any help would be appreciated!</P> Thu, 30 Mar 2023 21:42:07 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Inventory-amounts-shown-on-Map/m-p/3164354#M7243 srlozier 2023-03-30T21:42:07Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Inventory-amounts-shown-on-Map/m-p/3165279#M7246 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/539324">@srlozier</a>&nbsp;, if you can share the data in excel or PBIX file, it will be much easier to draft one for you.</P> Fri, 31 Mar 2023 08:43:59 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Inventory-amounts-shown-on-Map/m-p/3165279#M7246 Walter_W2022 2023-03-31T08:43:59Z