topic Re: Power BI Embedded : Cant doCross Filtering selecting multiple rows on a table visual pressing C in Developer

Power BI Embedded : Cant doCross Filtering selecting multiple rows on a table visual pressing CTRL

Hugo_Gallardo — Thu, 24 Feb 2022 20:06:39 GMT

Hello I have the following problem:

We have embedded different visuals from a PBIX file onto a asp.net core razor view.

We have achieved that when a user clicks on a row in a table visual, detect the item and corssfilter the other embedded visuals as the user clicks.

On the Power BI environment you can do the same, but by pressing the CTRL key, you can select multiple rows and then it will filter the whole visuals on that page.

As we achieved the crossfiltering selecting just one we thought it would do the same by pressing CTRL, the problem is that PowerBI Embedded visual is not detecting the CTRL key and it is not actually detecting that we are selecting more than one row and it changes the whole filters to the first selected row.

We are detecting via JS the CTRL key

After we click in more than one row or item, the event is lost and we can't get the list that the user was selecting:

We have tried the following without results:

1. document.addEventListener('keydown', function(event) {
console.log(event.key);
}, false);

document.addEventListener('keydown', prueba);

function prueba(e) {
console.log(e.KeyCode);
}

$("#Tb3").keypress(function() {
console.log( "Handler for .keypress() called." );
});

$(document).bind("keyup keydown", function(e){
console.log(e);
});

Do you have any suggestion to help us achieve our goal?

Re: Power BI Embedded : Cant doCross Filtering selecting multiple rows on a table visual pressing C

Anonymous — Mon, 28 Feb 2022 07:41:28 GMT

Hi @Hugo_Gallardo ,

Please review the following links, hope they can help you.

codesamples.js

dataselection.js

How to handle events

report: models.IReport page: models.IPage visual: models.IVisual filters: IFilter[] dataPoints: IIdentityValue[]

Best Regards

Re: Power BI Embedded : Cant doCross Filtering selecting multiple rows on a table visual pressing C

abner — Tue, 01 Mar 2022 22:14:17 GMT

Hi @Anonymous

I have tried in the following way, as you propose, but without success

With the dataSelected event I can't get the Ctrl event

Re: Power BI Embedded : Cant doCross Filtering selecting multiple rows on a table visual pressing C

Hugo_Gallardo — Thu, 31 Mar 2022 21:07:26 GMT

I have tried in the following way, as you propose, but without success

With the dataSelected event I can't get the Ctrl event