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! Go to 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])
)
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |