Dashboard Filtered View not responding to Start/End Date Filter

Hi everyone, I’m having trouble with the right expression on a slice to reflect the data from the parameters selected on an interactive Dashboard. In the image below “Filters” is based on the Parameters table and Quotes is based on a slice with this expression. The top 3 expressions respond perfectly but when I add Start/End time it displays the blank screen. What’s the best expression for the Start/End Dates?

Any help would be outstanding! Thanks

AND(
CONTAINS([Depot],ANY(Parameters[Depot])),
CONTAINS([Assigned to],ANY(Parameters[Assigned to])),
CONTAINS([Quote Stage],ANY(Parameters[Quote Stage])),
CONTAINS([Quote Date],[Quote Date]>ANY(Parameters[Start Date])),
CONTAINS([Quote Date],[Quote Date]<ANY(Parameters[End Date]))
)

Solved Solved
0 34 888
1 ACCEPTED SOLUTION

Does the following expression help?

AND(
CONTAINS([Depot],ANY(Parameters[Depot])),
CONTAINS([Assigned to],ANY(Parameters[Assigned to])),
CONTAINS([Quote Stage],ANY(Parameters[Quote Stage])),

[Quote Date]>ANY(Parameters[Start Date]),

[Quote Date]<ANY(Parameters[End Date])
)

View solution in original post

34 REPLIES 34
Top Labels in this Space