Good afternoon,
I'm new to Power BI i have cretaed a couple of display dash boards, but i'm struggling with this stage. I two columns that i want to link certain rows together. I have a slicer so when i search the No. it shows how many we have in stock, but i want to have a matrix table to show the available serial numbers. this is the table in query, but when i go back the display the table splits them and doesn't link or group them. is there a way to go this?
Hi @DiperkGavin - Please share some sample data for reference and analysis on one drive.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! |  |
this is the raw data sample.
| Cost Amount | ||||||||||||||||||||||||
| No. | Location Code | Bin Code | Serial No. | |||||||||||||||||||||
| No. 2 | Description | Average Cost L | Inventory | Rem Qty | ||||||||||||||||||||
| 5162640 | Module AR - Diesel | 0.00 | 1 | |||||||||||||||||||||
| 1 | SPALDING | BIN1 | PET127451M | 0 | ||||||||||||||||||||
| Total Cost for Item | 0.00 | |||||||||||||||||||||||
| 5356925 | Tank GP-DEF (FX84309) | 0.00 | 19 | |||||||||||||||||||||
| 1 | SPALDING | BIN1 | A103827 | 0 | ||||||||||||||||||||
| 1 | SPALDING | BIN1 | A104366 | 0 |
this is how it then uploads into the transform data page.
this is how it then looks in the visual table page.
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
