Hi everyone!
Anyone knows how to extract data from a database that looks like this?
When I use Inspections, since everything has a one-to-one relationship with an audit_id number, I can easily create visuals from the different columns.
But when I try to use inspection_items, since there is a one-to-many relationship to the different “labels” and their corresponding “responses”, I am stuck and don’t know how to proceed.
On the first image below, I put the data in Excel as it helps me visualize it better. The left side shows how the data is downloaded from a website.
On the right is how I visualize it in my head so I can then create a visual in Power BI.
At this moment, I only know how to extract one single response per audit_id.
See second image showing what I have in Power BI.
The way I do it is that I choose the label field as part of the visualization, and then I add a filter that chooses only one label and display its corresponding response.
But if I do not know how to add additional labels.
I wish there was a way to transform the data in Power Query so I could see the different label options on the Data column in Power BI so I could choose what to display on a visual.
Please help. Thank you.
Best answer by jose.valdes
View original
