Hi, let me show you our use case:
We are embedding different visuals on one razor page, and we are also using javascript API on a asp.net core razor page.
This is the webapp, we have a slider and a selector (the selector is not showed cause the value is setted up on the “aplicar filtro” button.
We need to use “N” tables on one action so we can do the parametrics on every visual.
The function is the following:
function filter1() {
var a = $("#In1").val();
var b = $("#In2").val();
const filter1 = [{
$schema: http://powerbi.com/product/schema#basic,
target: {
table: "tCalendarioNestleN", //this is the first table we call with the slider, this actually is the only one that works and when is selected, it actually affects every visual on the screen. But this is not the only table we call. This is the first filter we send and works.
column: "SemanaNestle"
},
logicalOperator: "And",
conditions: [
{
operator: "GreaterThanOrEqual",
value: a
},
{
operator: "LessThanOrEqual",
value: b
}
]
},
{
$schema: http://powerbi.com/product/schema#basic,
target: {
table: "tProductos", // this is the second table we call, the column should affect as well the whole screen. We can actually affect a lot of tables within power BI but when we embed every visual we can’t get the same effect. We found this code on your database.
column: "cveCategoria"
},
logicalOperator : "In",
conditions:[{value : "SP"}] // this is the value setted up, we will have checkboxes for the user to select N values in an array which will be values “SP”, “MG”, etc and the user can see N table filters affecting that
}
]
var embedContainerC = $('#ChartFR')[0];
var reportC= powerbi.get(embedContainerC);
reportC.setFilters([filter1])
}
For now, we have two buttons affecting the dashboard separately and it works but we need that the user can select n values that affects table columns and does shows up in the webapp.
These are both filters working out in separate calls but we need to do every filter on every table in just one call:
function filter1() {
var a = $("#In1").val();
var b = $("#In2").val();
const filter1 = {
$schema: http://powerbi.com/product/schema#basic,
target: {
table: "tCalendarioNestleN",
column: "SemanaNestle"
},
logicalOperator: "And",
conditions: [
{
operator: "GreaterThanOrEqual",
value: a
},
{
operator: "LessThanOrEqual",
value: b
}
]
};
var embedContainerC = $('#ChartFR')[0];
var reportC= powerbi.get(embedContainerC);
reportC.setFilters([filter1])
}
function filter2() {
const filter2 = {
$schema: http://powerbi.com/product/schema#basic,
target: {
table: "tProductos",
column: "cveCategoria"
},
operator: "In",
values: ["SP"]
};
var embedContainerPortafolio = $('#ChartFR')[0];
var reportPortafolio = powerbi.get(embedContainerPortafolio);
reportPortafolio.setFilters([filter2])
}
We can call separate filters but we need them altogether.
We saw in your forum that this can’t be done but we don’t believe that’s accurate.
