Forum Discussion
How to make specific filter?
Hi,
in one of my report, i have data table with some filters and i try to make another filter based on a type date field. I try to show in this filter two "checkbox" where we can chose beteween "empty" or "not empty".As you can imagine, empty is to show only lines with no date and the other one is to show lines with date.
is someone have an iade about how to make it?
thank you.
Hello Yani,
Make a column
Date_Filled = IF([date] <> Blank(), "not empty", "empty")
Now put a slicer on this column
Adarsh
Mark my post as a solution if it solves your problem.
3 Replies
Hello Yani,
Make a column
Date_Filled = IF([date] <> Blank(), "not empty", "empty")
Now put a slicer on this column
Adarsh
Mark my post as a solution if it solves your problem.
Thank you for the answer. That's work very well!
novilpawarAdvocate I
Yani hi
Go to this link, you will have an idea to solve your problem.
note:- you have to create 2 measures with filter one without blank and one with blank (no date).
Regards,
Novil
If I answer you question, please mark my post as solution.