How to make specific filter?

[Yani]

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. 

[Anonymous · Accepted solution]

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.

[Yani]

Thank you for the answer. That's work very well!

[novilpawar]

@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).

https://community.powerbi.com/t5/Desktop/Slicer-for-replacing-one-column-for-another/m-p/732579#M353...

Regards,

Novil

If I answer you question, please mark my post as solution.