Production slot visualization

[AndreasSchippan]

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.

Best regards,

Andreas

[rajendraongole1 · Accepted solution]

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.

Slot_Display =

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

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