Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Bump.
Just want to check if anyone has thoughts here
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |