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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ysapiyev
Responsive Resident
Responsive Resident

How to set two categorical vew mapping

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?

1 ACCEPTED SOLUTION
v-viig
Community Champion
Community Champion

It's native Power BI visuals. Multi data views are not supported by Power BI Custom Visuals API.

Please also note this repo is deprecated. Pleae don't rely on code in this repo anymore.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

View solution in original post

9 REPLIES 9
v-viig
Community Champion
Community Champion

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

ysapiyev
Responsive Resident
Responsive Resident

@v-viig,

 

Did you have a chance t look at my capavilities file? I'm stack at this problem.

v-viig
Community Champion
Community Champion

As far as I know, Power BI Custom Visuals API doesn't support two or more dataViews.

Please use the single dataView in categories to resolve the issue.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

ysapiyev
Responsive Resident
Responsive Resident

@v-viig,

 

Ok. Thank you. 

 

Since visuals don't support more than one dataview, why does combo chart's capabilities file have three of them?

v-viig
Community Champion
Community Champion

What combo chart are you talking about?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

ysapiyev
Responsive Resident
Responsive Resident

v-viig
Community Champion
Community Champion

It's native Power BI visuals. Multi data views are not supported by Power BI Custom Visuals API.

Please also note this repo is deprecated. Pleae don't rely on code in this repo anymore.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

ysapiyev
Responsive Resident
Responsive Resident

@v-viig,

 

Ok, thank you.

ysapiyev
Responsive Resident
Responsive Resident

@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"
                }
              }
            ]
          }
        }
      }
    }
  ]
}

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.