Forum Discussion
Maximum Capacity Data Display
Hi NMC20
I honestly don't quite get this statement.
My other sticking point is that I would have to do this 10 times for all the different sizes of product. Not only would this look messy but, when I filter to a site a that does not have size "large" (for example), the "large" chart would still display. The reason you're seeing all the sizes is likely because your data isn't formatted correctly for reporting. Instead of having a separate column for each size, you should have a single column for the size and another for the corresponding available quantity. This structure makes it easier to slice and dice the data without needing to create multiple visuals. The solution is to unpivot all columns except for the Location column.
Play around with the attached pbix.
Thank you for the attached, I think a slicer is probably my best route, you're right.
My bigger concern is how to display the max capacity issue - I want to see how regularly we're getting close to maximum capacity but I can't figure out how to display that.
In the sample pbix, there is a dates table connected to Transactions table so you can use that to filter the visual down to a selected date.