Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
AndreasSchippan
Regular Visitor

Production slot visualization

Hi all,

 

I have a questions about visualization of production slots. 

We have defined per unit type a min and a max quantity. lets say each the Maschine A & B has a min of 1 and a max of 3 units. Now I want to show a visual like the drawn one below. Each unit is in a separate column. in case we do not have 3 units on stock, the last box should be transparent (see second image). I now just painted that as I have no idea, how I could build this in Power BI.

 

AndreasSchippan_1-1741872342940.png

AndreasSchippan_2-1741872750657.png

 

Best regards,

Andreas

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @AndreasSchippan  - If you want a more customized look, you can:

Use a Table Visual with Machine & Slot.
Add a Custom Measure to display an icon (e.g., square emoji 🟨 for filled, or an empty character for transparent).
Use a Card Visual for each slot, layered in a grid format.

rajendraongole1_0-1741874167324.png

Slot_Display =
IF( SELECTEDVALUE('Table'[Property Code]) = 1135, "🟨", "" )

 

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
rajendraongole1
Super User
Super User

Hi @AndreasSchippan  - If you want a more customized look, you can:

Use a Table Visual with Machine & Slot.
Add a Custom Measure to display an icon (e.g., square emoji 🟨 for filled, or an empty character for transparent).
Use a Card Visual for each slot, layered in a grid format.

rajendraongole1_0-1741874167324.png

Slot_Display =
IF( SELECTEDVALUE('Table'[Property Code]) = 1135, "🟨", "" )

 

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.