Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Problem with reading data from dataview

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);
1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@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.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.