topic Re: How to Build SelectionID for table visual (Source Code) in Developer

How to Build SelectionID for table visual (Source Code)

chotu27 — Thu, 10 Aug 2017 16:33:41 GMT

Hi ,

Can you anyone let me know how to build selectionId in table visual or direct me to its Source code.

Re: How to Build SelectionID for table visual (Source Code)

v-viig — Fri, 11 Aug 2017 07:46:10 GMT

Please use this code as an example and current workaround:

getSelectionIds(dataView: DataView, host: IVisualHost): ISelectionId[] {
    return dataView.table.identity.map((identity: DataViewScopeIdentity) => {
        const categoryColumn: DataViewCategoryColumn = {
            source: dataView.table.columns[0],
            values: null,
            identity: [identity]
        };

        return host.createSelectionIdBuilder()
            .withCategory(categoryColumn, 0)
            .createSelectionId();
    });
}

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: How to Build SelectionID for table visual (Source Code)

chotu27 — Sun, 20 Aug 2017 01:36:24 GMT

Hi Ignat

I tried to create selection id's with the workaround that you have sent. But its not working. The code just breaks at

return host.createSelectionIdBuilder()
            .withCategory(categoryColumn, 0)
            .createSelectionId();
    });

statement giving no errors. I do not know how createSelectionIdBuilder is working. Please help

Re: How to Build SelectionID for table visual (Source Code)

v-viig — Mon, 21 Aug 2017 07:46:14 GMT

Hello @chotu27

Can you share source code? It that possible?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: How to Build SelectionID for table visual (Source Code)

chotu27 — Mon, 21 Aug 2017 19:35:05 GMT

Hi @v-viig

I can share you apart of it.

Here is the source code

Everything else seems to be working fine. It is only at that line where i am trying to create selection id's is what's not working.

//function for dataModelling
 public visualTransform(options: VisualUpdateOptions, host: IVisualHost):TableBarViewModel {
         let iValueFormatterPercent = ValueFormatter.create({ format: "0 %;-0%;0%" });   
         var dataViews =this.dataView = options.dataViews[0];
         let tableSelectionId: ISelectionId[] = this.getSelectionIds(dataViews,host);



//selection id function
public getSelectionIds(dataView: DataView, host: IVisualHost): ISelectionId[] {
 
return dataView.table.identity.map((identity: DataViewScopeIdentity) => {
const categoryColumn: DataViewCategoryColumn = {
source: dataView.table.columns[0],
values: null,
identity: [identity]
};
return host.createSelectionIdBuilder()
.withCategory(categoryColumn, 0)
.createSelectionId();
})
};


capabilities.json
"dataRoles": [
    {
      "displayName": "Values",
      "name": "values",
      "kind": "GroupingOrMeasure"
    }
  ],
  "dataViewMappings": [ 
    {    
      "conditions": [
        {
          "values": {
            "min": 1,
            "max": 25
          }
        }
      ],
       "table": {
          "rows": {
              "select": [{"for": { "in": "values" }}]
        }
    }
       }

  ],

Re: How to Build SelectionID for table visual (Source Code)

v-viig — Tue, 22 Aug 2017 08:15:40 GMT

This code works well for me.

Are you sure that another part of the code works properly?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: How to Build SelectionID for table visual (Source Code)

chotu27 — Wed, 23 Aug 2017 18:00:16 GMT

@v-viig Hi Ignat,

I already shared you my complete source code to your messages can you please check that and give me reply.

Re: How to Build SelectionID for table visual (Source Code)

v-viig — Thu, 24 Aug 2017 07:58:36 GMT

Hello @chotu27

Code has been updated. Please take a llok at the private message.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: How to Build SelectionID for table visual (Source Code)

Anonymous — Wed, 10 Apr 2019 07:15:23 GMT

Hello,

Could you please share with me your code?

Re: How to Build SelectionID for table visual (Source Code)

v-evelk — Fri, 12 Apr 2019 09:20:01 GMT

Hello,

I see that selection for table requires some hack.

Hopefully, a new API 2.5 which will be released next week contains .withTable method of the builder that must solve selection issues with Table mapping.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com