Forum Discussion
How to set two categorical vew mapping
- 8 years ago
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
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
- ysapiyev8 years agoResponsive Resident
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" } } ] } } } } ] } - ysapiyev8 years agoResponsive Resident
- v-viig8 years agoCommunity 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