topic Select with SelectionManager by rows instead of by category in Developer

Select with SelectionManager by rows instead of by category

JohnTheDoe — Tue, 24 Jul 2018 02:23:27 GMT

In my dataview I have a table where each row contains 3 columns. Is there a way for me to tell the Selection Manager to select the a specific row in the DataView?

I've learned how to do it by category, which is quite simple and useful, but I'm at a loss on how to do it by rows from a given table in the DataView.

Re: Select with SelectionManager by rows instead of by category

v-viig — Tue, 24 Jul 2018 17:43:28 GMT

To select data by row you should generate a SeletionId for each row by ushing this code:

/** This is TypeScript method */
private static getSelectionIds(dataView: DataView, host: IVisualHost): powerbi.visuals.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();
    });
}

After that, you will be able to use SelectionManager to select particular rows.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Select with SelectionManager by rows instead of by category

Anonymous — Fri, 24 May 2019 08:49:10 GMT

Hi, identity: DataViewScopeIdentity is not working anymore. Do you any suggestions ?