Forum Discussion

PBIcustomizer's avatar
PBIcustomizer
Frequent Visitor
8 years ago

DataViewMappings for hierarchical data with partial filtering

I have two groupings (category and subcategory), which I would like to represent in a hierarchical way in a custom visual. Additionally to the measures filtered on the combinations of the two groupi...
v-viig's avatar
v-viig
Community Champion
8 years ago

Hello PBIcustomizer

 

Totals and subtotals ara not supported by Power BI Custom Visuals API yet.

They are in backlog but there's no ETA.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]

  • PBIcustomizer's avatar
    PBIcustomizer
    Frequent Visitor
    8 years ago

    Hello,

     

    Thanks for your reply.

    Another option would be to use two category fields, one just for "Category" and a second one with "Category" and "Subcategory" (configured as groupings). Can I configure a DataViewMapping that works like this? it would be easy to do with two mappings, but as far as I know this is not possible.

    Any other way out?

     

    • v-viig's avatar
      v-viig
      Community Champion
      8 years ago

      Yes're correct. Power BI Custom Visuals API doesn't support multiple data-views at lest for now.

      I suppose that you might use the table mapping for your case.

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

      • PBIcustomizer's avatar
        PBIcustomizer
        Frequent Visitor
        8 years ago

        How exactly could I do that?

        Currently I have this:

         

        {
    "dataRoles": [
        {
            "displayName": "Category 1",
            "name": "category",
            "kind": "Grouping"
        },
        {
            "displayName": "Category 1 & 2",
            "name": "category2",
            "kind": "Grouping"
        },
        {
            "displayName": "Measure Data",
            "name": "measure",
            "kind": "Measure"
        }
    ],
    "dataViewMappings": [
        {
            "conditions" : [
                {
                    "category": { "max": 1 },
                    "category2": { "max": 2 }
                }
            ],
            "table": {
                "rows": {
                    "select": [
                        { "bind": { "to": "measure" } },
                        { "for": { "in": "category" } },
                        { "for": { "in": "category2" } }
                    ]
                }
            }
        }
    ]
}

        Basically, I want the measures filtered by 'category' AND (completely separately) filtered by everything in 'category2'. That's not what this mapping does - how can I change it to get what I need?

         

        For example: if Category and Subcategory are two columns in my data, I would be to put Category in the 'category' field and Category AND Subcategory in the 'category2' field. The filtering by 'category' would give the aggregate values per Category and filtering by 'category2' would give the values one level further down in the hierarchy, for each combination of Category and Subcategory.