topic Re: Custom visual extract data from dataset in Developer

Custom visual extract data from dataset

wellsayd — Tue, 27 Feb 2018 18:33:08 GMT

I have a column of 130 or so rows that contain either A,B,C,D,E,F ... When I try to access the

table.rows, all of the duplicate rows have been grouped together with no indication of how many there are.

Preferably, I would like to access the data without PowerBi grouping the duplicates and allow me to do my own analysis in Typescript.

Any suggestions and thank you.

Re: Custom visual extract data from dataset

v-viig — Wed, 28 Feb 2018 07:25:05 GMT

Grouping is default behavior of Power BI.

The possible solution here is to add a Measure column to capabilities.json and put the main data column as Count of elements.

This solution will allow your custom visual to get how many items are there.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Custom visual extract data from dataset

wellsayd — Wed, 28 Feb 2018 14:34:59 GMT

Thank you for your response. I am currently digging around for examples for what you are describing ... Currently, I have

{

"dataRoles": [

{

"displayName": "Values",

"name": "values",

"kind": "Grouping"

}

"dataViewMappings": [

{

"table": {

"rows": {

"for": {

"in": "values"

}

]

}

Any suggestions would be much appreciated.

Re: Custom visual extract data from dataset

wellsayd — Wed, 28 Feb 2018 15:18:12 GMT

Ok I think I have what you are describing.

{
  "dataRoles": [
    {
            "displayName": "Category",
            "name": "Category",
            "kind": "Grouping"
        },
        {
            "displayName": "Values",
            "name": "Values",
            "kind": "Measure"
        }
  ],
  "dataViewMappings": [
      {

          "table": {
              "rows": {
                  "for": {
                      "in": "values"
                  }
              }
          }
      }
  ]
}

Then in the Values Field, select the drop down and select Count. See attached screen shot as a reference.

Re: Custom visual extract data from dataset

wellsayd — Wed, 28 Feb 2018 15:28:52 GMT

Is there anyway to make the Count automatically occur?

Also, with the previous workflow ... all of the null or missing fields do not receive a count and it is part of the requirements.

Thank you for help !!

Re: Custom visual extract data from dataset

v-viig — Thu, 01 Mar 2018 07:35:36 GMT

As far as I know, there's no way to use Count by default.

Regarding null issue. It seems you should turn on "Shows items with no data":

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Custom visual extract data from dataset

wellsayd — Thu, 01 Mar 2018 22:13:49 GMT

Thank you for the help.

The null value appears when you are just displaying the field.

But, the null value dissappears when you apply Count to the field.

Please see screenshots as a reference.

Re: Custom visual extract data from dataset

v-viig — Fri, 02 Mar 2018 07:41:08 GMT

Looks like it's limitation of categorical data view mapping.

We'd recommend that you should try table view mapping out.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Custom visual extract data from dataset

wellsayd — Fri, 02 Mar 2018 15:51:55 GMT

I am using table view mapping.

Re: Custom visual extract data from dataset

v-viig — Mon, 05 Mar 2018 08:22:04 GMT

Power BI doesn't support Count aggregation for null values.

You might propose an idea to support Count for null values.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com