How do I make the fields from a table to not occur only once in that category?

[Flyingwarrior]

Hello,

I'm new to Power BI development, I got a basic problem. I'd like to get the data from a table which contains 2 columns, multiple fields from the second column could be related to a field in the first column. The table looks like this:

My capabilites.json is quite similar to the BarChart tutorials's, you can be view it in the Tutorial: Build a bar chart.

When I console.log my dataView[0] I can see the source/values of the 'categories' and 'values' but I only got a list of the fields in each column, so the fields in the left column occur only once. Each value array contains 83 strings.

My goal is to get the data from the table which has exactly 2 columns and 447 rows.

Are my capabalities configurations not fit for this task? Is there a value in the dataView object which is responsible for the relations between the fields?

If you have any tips to what method I should use for this, please let me know.

[Flyingwarrior · Accepted solution]

Found the solution:

"table": {
    "rows": {
        "select": [
            { "for": { "in": "name-col" } },
            { "for": { "in": "imports-col" } }
        ]
    }
}

Correctly returns each row