Hi,
Using power BI embedding I am creating tables on fly by calling "create" endpoint from power bi authoring. When users selects/clicks on a cell in a table I want to capture the cell value and the column that was selected. I tried listening to "dataselected" event and it gives entire row but it will not tell which column is selected in that row. Is there a way for me to identify which row and column got selected?
this.report.on("dataSelected", function (event: any) {
console.log("dataSelected")
console.log(event.detail) // able to see enitre row. Instead need a way to identify the column selected along with selected row.
}
Example :
| Company | Department | Sales | Profit |
| ABC | D1 | $200 | $100 |
| DEF | D2 | $300 | $50 |
In above example Sales and Profit columns are value columns.
Now if uses clicks/selects $100 I want to programatically capture selected row and selected column with in selected row. i.e. as part of selected row I want to see "Company:ABC,Department:D1, Sales:$200, Profit:$100" and as part of selected column I want to see "Profit:$100". Is there any way to acheive this?
