Custom Visualization: capabilities.json & table definition with multiple columns

[Anonymous]

We have multiple columns defined in our data roles definition and need to be able to define them in our corresponding table.  All of the examples are showing only 1 column within the table:

"dataViewMappings": [
    {
        "table": {
            "rows": {
                "for": {
                    "in": "values"
                }
            }
        }
    }
]

We've tried to have multiple 'for' objects, multiple 'in' objects but PBI won't compile the definitions.  Is there a way we can define multiple columns within this table definition?  In v1.9, we got our table for free and now we're attempting to recreate the definition in v2.3 but cannot with our custom visualization.  

our data roles:

"dataRoles": [

{

"displayNameKey": "Visual_Source",

"name": "Source",

"kind": "GroupingOrMeasure",

"displayName": "Source"

},

{

"displayNameKey": "Visual_Target",

"name": "Target",

"kind": "GroupingOrMeasure",

"displayName": "Target"

},

{

"displayNameKey": "Visual_Weight",

"name": "Weight",

"kind": "GroupingOrMeasure",

"displayName": "Weight"

}, ...

@v-viig 

[Anonymous]

from here:

https://github.com/Microsoft/PowerBI-visuals-tools/blob/master/templates/visuals/.api/v2.3.0/schema....

[v-evelk]

Hello,

Please try the following example.

    "dataRoles": [{
        "name": "Fields",
        "kind": "Grouping",
        "displayName": "Fields"
    }, {
        "name": "Values",
        "kind": "Measure",
        "displayName": "Values"
    }],
    "dataViewMappings": [{
        "table": {
            "rows": {
                "select": [{
                        "for": {
                            "in": "Fields"
                        }
                    },
                    {
                        "for": {
                            "in": "Values"
                        }
                    }
                ]
            }
        }
    }],

We will add examples with serveral columns to our documentation.

Thanks!

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]