Forum Discussion
Product usage tracking multiple items in one row
Hello All,
I am an avid Excel user, but I am new to Power BI and would like some direction. I created an example that mirrors what I am trying to achomplish.
Scope: The owner of a used car dealership wants to track what vehicles are being test driven. Sometimes a salesman will test drive multiple cars on one day.
Picture of Excel data
This is how I would like to display the data in Power BI
I am able to create a relation between test drive 1 and the product details of each car; however, I cannot determine a way to connect all test drives to the product details. I have tried adding relationships, but I can only have one relationship active.
An example of what I am trying to show is the month of January should have seven test drives.
If its an easy solution that I am missing and there are places where I can learn, please let me know!
Thank you!
HuskyMan , One very clear as data shared above has different column than one in relation diagram.
But seem like unpivot the test drive 1, test drive 2, test drive 3 , is an option to be explored
https://radacad.com/pivot-and-unpivot-with-power-bi
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
2 Replies
- amitchandak
Super User
HuskyMan , One very clear as data shared above has different column than one in relation diagram.
But seem like unpivot the test drive 1, test drive 2, test drive 3 , is an option to be explored
https://radacad.com/pivot-and-unpivot-with-power-bi
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Are you asking for my data in this format?
Date Salesman Test Drive 1 Test Drive 2 Test Drive 3 1/1/2021 Jim Focus Prius 1/7/2021 Bob F150 Escape Corolla 1/13/2021 Mike Escape Corolla 2/5/2021 Bob Prius Corolla RAV4 3/5/2021 Mike Corolla 3/23/2021 Mike RAV4 3/25/2021 Bob RAV4 Prius 3/25/2021 Bob Escape 3/25/2021 Bob Fuision 4/4/2021 Jim Prius F150 Corolla 4/8/2021 Jim Focus 4/9/2021 Mike F150 Escape 4/12/2021 Bob Focus 5/13/2021 Mike RAV4 Prius 6/5/2021 Jim RAV4 Car Manufacturer Class Price Focus Ford Sedan 18500 Prius Toyota Hybrid 24000 Escape Ford SUV 25000 RAV4 Toyota SUV 27000 Corolla Toyota Sedan 20000 F150 Ford Truck 30000 So basically that feature seperates the row into multiple entries to format the data for Power BI. I think thats the solution I needed.
