Hi Roman-Korovets,

The property pane only supports measures added via conditional formatting, which are scalar values and bound to objects in the data view. It would not be possible to have a table or array-valued result unless you create a measure that serialises your data into something you could deserialise once you have recieved the property (e.g. a comma-separated list using CONCATENATEX that you could split into an array via JS).

The "right" way to do this via the SDK would be to create data roles for each measure and model your data so that all values could be part of that query and mapped once you process the data view. This of course means that your users may have to have very specific requirements as to how they model data for your visual.

Regards,

Daniel

dm-p, 

Thank you so much for detailed answer   😊

To be honest, I'm not sure If I have chosen the correct way for achieving separate lists.
Could you tell me if exists any way to avoid duplication around data mapping from different tables.
For now, I have “1 task” and “5 events”,
In the result, we see task “5 times" instead “1 time”.

I would like to have 2 separate lists, if it is possible:
"tasks" - 1 item
"events" - 5 items

I guess reason is in dataViewMappings.

Capabilities.json:

{
  "privileges": [],
  "dataRoles": [
    {
      "displayName": "Tasks and Hierarchy",
      "name": "Tasks",
      "kind": "Grouping"
    },
    {
      "displayName": "Start Date",
      "name": "StartDate",
      "kind": "Measure"
    },
    {
      "displayName": "Dynamic event",
      "name": "DynamicEvent",
      "kind": "Measure"
    },
    {
      "displayName": "Dynamic event label",
      "name": "DynamicEventLabel",
      "kind": "GroupingOrMeasure"
    }
  ],
  "dataViewMappings": [
    {
      "matrix": {
        "rows": {
          "for": {
            "in": "Tasks"
          },
          "dataReductionAlgorithm": {
            "top": {
              "count": 30000
            }
          }
        },
        "values": {
          "select": [
            {
              "for": {
                "in": "StartDate"
              }
            },
            {
              "for": {
                "in": "DynamicEvent"
              }
            },
            {
              "for": {
                "in": "DynamicEventLabel"
              }
            }
          ]
        }
      }
    }
  ],
  "advancedEditModeSupport": 2
}

Thank you in advance 🤗