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
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
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.
