cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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 

2 REPLIES 2
Anonymous
Not applicable

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

Microsoft v-evelk
Microsoft

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

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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors