Forum Discussion
Sagimore88
4 years agoFrequent Visitor
Blank In Search Filter
Hello 🙂 I have slicer on the page that is a measure- It is taking a value from a datefiff column and returning text. Column is a datefiff in months - Overdue Period = DATEDIFF('Policy DimPolicy...
- 4 years ago
Sagimore88 , Refer why blank in slicer, see if that can help
v-chenwuz-msft
4 years agoCommunity Support
Hi Sagimore88 ,
This is a small mistake. Change And to Or.
And means items which does not contain exclude, and the same time it should be no blank. But blank does not match "does not contain" this situation. So, please change to Or.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.