Problem with reading data from dataview

Anonymous — Tue, 20 Jun 2017 15:07:22 GMT

I have my capabilities.json as follow:

{
    "dataRoles": [
        {
            "displayName": "Origine",
            "name": "category",
            "kind": 0
        },
        {
            "displayName": "Volume",
            "name": "measure",
            "kind": 1
        },
        {
            "displayName": "Age",
            "name": "age",
            "kind": 1
        }
    ],
    "dataViewMappings": [
        {
            "conditions": [
                {
                    "category": {
                        "max":1
                    },
                    "mesure": {
                        "max":1
                    },
                    "age":{
                        "max":1
                    }
                }
            ],

            "categorical": {
                "categories": {
                    "for": {
                        "in": "category"
                    }
                },
                "single": {
                    "for": {
                        "in": "age"
                    }
                },
                "values": {
                    "select": [
                        {
                            "bind": {
                                "to": "measure"
                            }
                        }
                    ]
                }
            },
            "single" : {
                "role":""
            }    
        }
    ],

i'm trying to read the the data "age" but I couldn't achieve this.

here is the way with which I'm trying to read the data:

            console.log(options.dataViews[0]);
            console.log(options.dataViews[0].categorical.maps);

Re: Problem with reading data from dataview

v-chuncz-msft — Wed, 21 Jun 2017 09:49:21 GMT

@Anonymous,

The above capabilities.json is not valid. You may check the API at https://github.com/Microsoft/PowerBI-visuals-tools/blob/master/templates/visuals/.api/v1.7.0/schema.capabilities.json.

topic Re: Problem with reading data from dataview in Developer

Problem with reading data from dataview

Re: Problem with reading data from dataview