Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Capture selected datapoint for table using power BI embedding.

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 :

CompanyDepartmentSalesProfit
ABCD1$200$100
DEFD2$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?

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Just want to check if anyone has thoughts here