topic Re: How to set two categorical vew mapping in Developer

How to set two categorical vew mapping

ysapiyev — Fri, 02 Feb 2018 07:06:27 GMT

hi everyone,

I need to set two categoricl vew mapping. I looked to example of combo chart capabilities, however it does not work in my visual.

I have two categorial view, values in second are correct, however, categories are same as in first view. What can be the problem?

Re: How to set two categorical vew mapping

v-viig — Fri, 02 Feb 2018 07:52:26 GMT

Do you want ot use two or more categories in your own custom visuals?

Can you share your current capabilities.json?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: How to set two categorical vew mapping

ysapiyev — Fri, 02 Feb 2018 12:45:03 GMT

@v-viig

Here is my capabilities file. As I understood from tutorial on github, second dataviewmapping will result in two categorical data with different categories and values. When I use this code, I have two categorical data, but categories from first one also displayed in second one, whereas there is no "check_cat". At the same time, data for second categorical view displayed correctly.

{

  "supportsHighlight": true,
  "dataRoles": [
    {
      "displayName": "Item name compl",
      "name": "category",
      "kind": "Grouping"
    },
    {
      "displayName": "Dates",
      "name": "date",
      "kind": "Grouping"
    },
    {
      "displayName": "Dates well test",
      "name": "date_wr",
      "kind": "Grouping"
    },
    {
      "displayName": "check cat",
      "name": "check_cat",
      "kind": "Grouping"
    },
    {
      "displayName": "value1",
      "kind": "Measure",
      "name": "value1"
    },
    {
      "displayName": "value1 unit",
      "name": "value1_unit",
      "kind": "Measure"
    },

    {
      "displayName": "value2",
      "name": "value2",
      "kind": "Measure"
    },
    {
      "displayName": "value2 unit",
      "name": "value2_unit",
      "kind": "Measure"
    },
    {
      "displayName": "value3",
      "name": "value3",
      "kind": "Measure"
    },
    {
      "displayName": "value3 unit",
      "name": "value3_unit",
      "kind": "Measure"
    },
    {
      "displayName": "value4",
      "name": "value4",
      "kind": "Measure"
    },
    {
      "displayName": "value4 unit",
      "name": "value4_unit",
      "kind": "Measure"
    },
    {
      "displayName": "check val",
      "name": "check_val",
      "kind": "Measure"
    }
  ],
 
  "dataViewMappings": [
    {
      "categorical": {
        "categories": {
          "select": [
            {
              "for": {
                "in": "category"
              }
            },
            {
              "for": {
                "in": "date"
              }
            },
            {
              "for": {
                "in": "date_wr"
              }
            }
          ]
        },
        "values": {
          "group": {
            "by": "date",
            "select": [
              {
                "bind": {
                  "to": "value1"
                }
              },
              {
                "bind": {
                  "to": "value1_unit"
                }
              },
              {
                "bind": {
                  "to": "value2"
                }
              },
              {
                "bind": {
                  "to": "value2_unit"
                }
              },
              {
                "bind": {
                  "to": "value3"
                }
              },
              {
                "bind": {
                  "to": "value3_unit"
                }
              },
              {
                "bind": {
                  "to": "value4"
                }
              },
              {
                "bind": {
                  "to": "value4_unit"
                }
              }
            ]
          }
        }
      }
    },
    {
      "categorical": {
        "categories": {
          "select": [
           
            {
              "for": {
                "in": "check_cat"
              }
            }
          ]
        },
        "values": {
          "group": {
            "by": "check_cat",
            "select": [
              {
                "bind": {
                  "to": "check_val"
                }
              }
            ]
          }
        }
      }
    }
  ]
}