Forum Discussion
linking data on different rows
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?
2 Replies
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!!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.
