Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |