Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

How to make different columns can be continued into 1 column and shown in a new table (Not combine)

Hi experts:

      The inspectors will input the below original table every day, I hope to create some charts in Report View page to show the defects quantity changes by the inspection date, product name, product type, so I need to create a new table, the new table will create rows by each defect, you can refer to the new table, because there are 9 defects in total in the original table, so the new table will have 9 rows, could you help check how to create the new table? 


Original Table

Inspection DateProduct NameProduct TypeDefect 1Defect 2Defect 3Defect 4
2023/1/1ASwitchBox BrokenSoldering FailLow BatteryProduct Scratch
2023/1/2ASwitchLow batteryProduct Scratch  
2023/1/3BMouseProduct broken Low battery  
2023/1/4BCableCable Disconnected   



New Table

Inspection DateProduct NameProduct TypeDefect 
2023/1/1ASwitchBox Broken
2023/1/1ASwitchSoldering Fail
2023/1/1ASwitchLow Battery
2023/1/1ASwitchProduct Scratch
2023/1/2ASwitchLow battery
2023/1/2ASwitchProduct Scratch
2023/1/3BMouseProduct broken
2023/1/3BMouseLow battery
2023/1/4BCableCable Disconnected



Super User
Super User
Super User
Super User

you need to make a duplicate of the table and then delete the unnecessary column and do what was shown in the video

Super User
Super User

Hi Ahmedx:

   Thank you very much for the reply! It's clear for me now!!!

   But I still have a question, I don't want to edit the data in the original table, because there are multiple columns in it, so I want to create a new table only contains the Inspection Date/Product Name/Product Type/Defect, could you help tell me how to make it?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors