Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi! I try add power bi report to my application. I have report with many bookmarks and query. All works fine while i use filter which have date, but when in the table don't consist data i see all my data in visuals.
// Get models. models contains enums that can be used.
var models = window['powerbi-client'].models;
const filter =
{
$schema: "http://powerbi.com/product/schema#basic",
target: {
table: "State",
column: "Title"
},
operator: "In",
values: ["London"]
};
const filter_rails =
{
$schema: "http://powerbi.com/product/schema#advanced",
target: {
table: "Rails",
column: "DateDeparture"
},
logicalOperator: "And",
conditions: [{
operator: "LessThanOrEqual",
value: "2019-05-31 12:00:00"
},
{
operator: "GreaterThanOrEqual",
value: "2019-05-30 12:00:00"
}]
};
const filter_prod =
{
$schema: "http://powerbi.com/product/schema#advanced",
target: {
table: "Production",
column: "DataDate"
},
logicalOperator: "And",
conditions: [{
operator: "LessThanOrEqual",
value: "2019-05-31 12:00:00"
},
{
operator: "GreaterThanOrEqual",
value: "2019-05-01 12:00:00"
}]
};
If table Production doesn't have value report shows all data (doesn't apply any filters)
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |