Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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
Hi, identity: DataViewScopeIdentity is not working anymore. Do you any suggestions ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |