Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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
}
};
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |