Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hello All,
I am trying to apply two date filter like
defaultFunnelDateFilter OR defaultFunnelDateFilter1
How can I filter based both date range? Is there any keyword to add OR condition between two Date range.
var defaultFunnelDateFilter = {
$schema: "http://powerbi.com/product/schema#advanced",
target: {
table: "tbl_Funnel",
column: "DateCreated"
},
logicalOperator: "And",
conditions: [
{
operator: "GreaterThanOrEqual",
value: window.sd
},
{
operator: "LessThanOrEqual",
value: window.ed
}
]
}
var defaultFunnelDateFilter1 = {
$schema: "http://powerbi.com/product/schema#advanced",
target: {
table: "tbl_Funnel",
column: "DateCreated"
},
logicalOperator: "And",
conditions: [
{
operator: "GreaterThanOrEqual",
value: "1999-12-31T00:00:00.000Z"
},
{
operator: "LessThanOrEqual",
value: "2000-01-02T00:00:00.000Z"
}
]
}
var defaultClientFilter = {
$schema: "http://powerbi.com/product/schema#advanced",
target: {
table: "tbl_Leads",
column: "ClientCode"
},
operator: "In",
values: window.selectedClient
};and in in the config, I am doing like
var config = {
type: 'report',
tokenType: models.TokenType.Embed,
accessToken: EmbedConfig.EmbedToken.Token,
embedUrl: txtEmbedUrl,
id: txtEmbedReportId,
permissions: permissions,
viewMode: viewMode,
filters: [ defaultFunnelDateFilter1, defaultFunnelDateFilter , defaultClientFilter ],
settings: {
filterPaneEnabled: false,
navContentPaneEnabled: false
}
};
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |