topic Re: DataViewMappings with both table and categorical. in Developer

DataViewMappings with both table and categorical.

michal089 — Tue, 11 Sep 2018 07:16:42 GMT

Hi!

Lately I came across the situation in which I have to define two different data view mappings. Being precise, I have to define both table and categorical mappings.

My code is:

    "dataViewMappings": [
        {
            "table": {
                "rows": {
                    "for": {
                        "in": "branches"
                    }
                }
            },
            "categorical": {
                "categories": {
                    "for": { "in": "category" }
                },
                "values": {
                    "select": [
                        { "bind": { "to": "value" } }
                    ]
                }
            }
        }
    ]

But that code won't compile :

 error  JSON  capabilities.json :  instance.dataViewMappings[0] is not exactly one from [subschema 0],[subschema 1],[subschema 2],[subschema 3],[subschema 4]

What am I doing wrong ?

Edit1:

I tried to create two dataViewMappings but for some reason my visual has crashed:

    "dataViewMappings": [
        {
            "table": {
                "rows": {   
                    "select": [
                        {
                            "for": {
                                "in": "measure1"
                            }  
                        },
                        {
                            "for": {
                                "in": "measure2"
                            }  
                        }
                    ]
                }
            }
        },
        {
            "categorical": {
                "categories": {
                    "for": {
                        "in": "categories"
                    }
                },
                "values": {
                    "select": [
                        {"bind": {
                            "to": "values"
                        }}
                    ]
                }
            }
        }
    ]

It seems that pbiviz does not support multiple queries. Anyone tried to create more then one dataViewMapping?

Any help would be much appreciated.

Michal

Re: DataViewMappings with both table and categorical.

Nafferty — Wed, 12 Sep 2018 21:16:03 GMT

Multiple dataViewMappings are not supported currently, which is a pain. I've basically been creating larger than necessary data tables in my model and passing those in, and then transforming the data into the format I need in my JavaScript before rendering my visuals.

https://github.com/Microsoft/PowerBI-visuals/issues/251

Re: DataViewMappings with both table and categorical.

v-viig — Wed, 19 Sep 2018 07:04:32 GMT

No plans to support multi-data mapping. Please use one mapping (e.g. table or categorical).

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: DataViewMappings with both table and categorical.

rahulvartak — Tue, 13 Aug 2019 04:24:11 GMT

Hi Ignat,

If I want to pass the value of a single calculated measure along with my categorical dataview, is it possible ?

Thanks & Regards,

Rahul

Re: DataViewMappings with both table and categorical.

akshaytech9 — Mon, 08 Nov 2021 09:10:14 GMT

Hi @v-viig,

Adding to the question raised by @rahulvartak, could you please let us know whether any single calculated measure value can be passed along with categorical dataview with many-to-one join relationship ?

Thanks,

Akshay

Re: DataViewMappings with both table and categorical.

Anonymous — Mon, 11 Mar 2024 08:30:57 GMT

Can i create two dataview objects for a single pbiviz project?