Forum Discussion

michal089's avatar
michal089
Frequent Visitor
7 years ago
Solved

DataViewMappings with both table and categorical.

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

 

 

5 Replies

  • Nafferty's avatar
    Nafferty
    Regular Visitor

    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

     

    • v-viig's avatar
      v-viig
      Community Champion

      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

      [email protected]

      • rahulvartak's avatar
        rahulvartak
        Frequent Visitor

        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

         

         

         

  • akshaytech9's avatar
    akshaytech9
    Regular Visitor

    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

  • Anonymous's avatar
    Anonymous
    Not applicable

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