topic Re: Custom Visualization: capabilities.json & table definition with multiple columns in Developer

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

Anonymous — Wed, 27 Mar 2019 15:18:09 GMT

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

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

Anonymous — Wed, 27 Mar 2019 15:41:34 GMT

from here:

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

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

v-evelk — Thu, 28 Mar 2019 11:34:18 GMT

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
pbicvsupport@microsoft.com