Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello.
I am looking to create an electronic kanban visual using Power BI. My goal is to bring in five fields of data.
These fields will be "Item Number","Maximum Inventory", "Minimum Inventory", "Safety Inventory", and "Current Inventory".
Each Item will have unique inventory levels based on the current demand of that Item, and these levels will change based on the item number and the current demand that it is currently experiencing (Live data will be pulled).
I would like to use "bars" to visualize how each "Max Inventory" level stacks up with with the other items. (This will allow a visual of the Items that are in the highest demands).
I would like each level to be displayed with a color. Maximum Inventory = Green. Minimum Inventory = Yellow. Safety Inventory = Red. The current inventory shall be displayed with a "line" that goes accross each bar.
Finally, I would like the Item number to be displayed as a color as well based on how the Current Inventory relates to the inventory demands stated above.
I have attached visuals below for reference.
I would like this to be done in Power BI based on the number of Items that I will be needing analysis on.
If anyone has something that they have used that is similar to this, please let me know. I have experimented with the Linear Gauge that X-Viz offers, however there doesn't seem to be an easy way to enter a multitude of items into this gauge.
Thank you in advance for anyone help, I greatly appreciate it!
Have you considered rolling your own visual with Charticulator or Deneb ?
I have not. I am fairly new to BI and am not sure exactly what that means. Are you able to give me some more insight on what those tools can accomplish?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |