dataviewmappings
4 TopicsPBIVIZ Multiple values in categorical data
I've mapped categorical data with a single measure in capabilities.json. It works with a single measure. But I need to add another measure. "dataViewMappings": [ { "categorical": { "categories": { "for": { "in": "category" }, "dataReductionAlgorithm": { "top": {} } }, "values": { "select": [ { "bind": { "to": "measure" } }, { "bind": { "to": "measure1" } } ] } } } When I add the second value "measure1" and print categorical to the console I see only a single array of "measure" but not "measure1". Does pbiviz support passing multiple values along categorical data?Table.columns.queryName property not updated after changing the aggregate function
I've created the following custom visual using a table Data View Mapping. If I added a column to my GroupingOrMeasure Data Role the table.columns.queryName property of this column takes the value of the first summarization option (which is sum): "Sum( Table.Column1 )". But if I change the aggregate function of this column to "Don't Summarize" (or any other), the queryName property doesn't update at all, is still "Sum( Table.Column1 )": Steps to reproduce this issue 1. Create the following table: 2. Create a custom visual with the following capability: Data Roles: "dataRoles": [ { "name": "columns", "kind": "GroupingOrMeasure", "displayName": "Columns" } ] Data View Mapping: "dataViewMappings": [ { "table": { "rows": { "select": [ { "for": { "in": "columns" } } ] } } } ] 3. Explore table.columns.queryName value with Show DataView button and see how this property is not updated after changing the aggregate function of Column1.Data view mapping in Power BI visuals
Good day I am creating custom visualization on d3js and pbiviz for powerbi Here is the code in capabilities.js: { "dataRoles":[ { "displayName": "HoleDepth", "name": "depth", "kind": "Grouping" }, { "displayName": "Days", "name": "days", "kind": "Measure" }, { "displayName": "Diametrs", "name": "diametrs", "kind": "Measure" }, { "displayName": "Sensor1", "name": "sensor_1", "kind": "Measure" }, { "displayName": "Sensor2", "name": "sensor_2", "kind": "Measure" }, { "displayName": "Sensor3", "name": "sensor_3", "kind": "Measure" }, { "displayName": "Sensor4", "name": "sensor_4", "kind": "Measure" } ], "dataViewMappings": [ { "categorical": { "categories": { "for": { "in": "depth" } }, "values": { "select":[ { "bind": { "to": "days" } }, { "bind": { "to": "diametrs" } }, { "bind": { "to": "sensor_1" } }, { "bind": { "to": "sensor_2" } }, { "bind": { "to": "sensor_3" } }, { "bind": { "to": "sensor_4" } } ] } } } ] } But in visualization it is inconvenient to use categorical -> values array Is it possible to categorical -> values was like an object with keys?:DataViewMapping Conditions Not Working as Expected
I'm having some trouble with setting up a condition containing a minimum requirement. Example: "conditions": [ { "x": { "max": 1 }, "y": { "min": 2 } } ], The goal is that until the user has mapped exactly one X and two or more Y fields, they will continue to see an error like this: What actually happens is that you can't map any fields at all. We could set up multiple conditions as "stepping stones" to get to the condition shown above, but that would completely defeat the purpose. The goal here is to display the included error message until the user has mapped all the necessary fields. Is this possible, or will we need to implement our own input validation and error display? powerbi-visuals-api: 2.5.0 powerbi-visuals-tools: 3.0.12 powerbi-visuals-utils-dataviewutils: 2.1.1