linking data on different rows

[DiperkGavin]

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?

[rajendraongole1]

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!!

[DiperkGavin]

hi @rajendraongole1 

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.