This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
I'm trying to figure out a way of using the Synoptic Panel for a client's inventory management needs. They provided me with a diagram of their warehouse with approximately 100 shelf locations. I've mapped these as areas using the Synoptic Panel Designer. It works fine when there is only one piece of equiment per shelf location. I'm running into problems when they have multiple items in the same shelf location because only one item is displayed in the visual. Is there any way to get around this without needing to create sub-areas within each shelf location. Does anyone know of a solution that would show a list of each item and their corresponding measures within each location?
I'd create a mapping table of the items and their location on the warehouse map. In most cases your mapping table will be 1 to 1 with the location map, but whenever you have multiple items in 1 map location, you would have an entry for each one.
Thanks for your response! I did try that. In the Synoptic Panel, when I have the subcategory poulated with the item name, it only shows one of multiple items. If I remove the subcategory and only have a measure, it totals the amount, price, etc. properly. I would like to show the names of each item along with their unique measures. Not sure how!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 21 | |
| 21 | |
| 14 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 47 | |
| 35 | |
| 24 | |
| 20 | |
| 19 |