Forum Discussion
How to Display Stock
Hello EduardoLIma,
If your data is structured in the following way:
Date Stamp Tank Juice Qty Parameter 1 Parameter 2 Parameter 3 Parameter 4 29/08/2023 1 Juice 1 374 3,0 2,0 1,0 2,0 29/08/2023 2 Juice 3 641 3,0 3,0 1,0 2,0 29/08/2023 3 Juice 2 296 2,0 1,0 2,0 3,0 I would suggest the following proposals:
Stacked Bar Chart - it will give a possibility to see at glance many tanks, however I suggest to add "Zoom slider" as you probably won't be able to visualize all values.
Matrix - you won't be able to see all tanks, but total row can help to have an idea of total stock, numbers are readable and conditional formatting is showing whether tank is full or not.
Table with sparkline - in case you need to show change of tank's filled capacity over time for all 120 tanks.For additional information on parameters I suggest to use a built-in tooltip for a bar chart and manually created one for matrix/table (video on tooltip).
I hope it will inspire you for creating a great report! 🙂
Thank you for your suggestions, I-ll be giving them a try! I was just attempting to put into excel how I imagine in my head i would like to visualize the info i Power BI, i'm posting a picture.
Something like this, except the colors would be determined by the product in each tank and then i'd also be able to see those parameters seen in the table (brix, ratio, etc) and the total kg of each tank would show instead of that date
Less is more. Add padding between each visual. Think in small multiples
that are immediately picked up by the user to tell a particular status. Think icons
and infographics. Just remember, this will be fun, folks will love it, and ask for more 🙂
Inviting technolog into the discussion. technolog , how would you approach this, thoughts?