Forum Discussion

JohnTheDoe's avatar
JohnTheDoe
Frequent Visitor
8 years ago
Solved

Select with SelectionManager by rows instead of by category

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 ca...
Tips and Tricks
  • v-viig's avatar
    v-viig
    8 years ago

    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

    [email protected]

v-viig's avatar
v-viig
Icon for Community Champion rankCommunity Champion
8 years ago

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

[email protected]

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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