CODEWITHSUNDEEP
powerbi
Efhache
Efhache

Reputation: 167

powerbi : slicer on date but with blank

I've a table with some datas and one of them is a date format, but some rows have "blank" date. I would like to use date slicer to show rows in a period (so date slice with 'between' format) BUT with always the blank data.

So, for example, if my slicer is a selecte period between 15 July and 16 July, I want to show all rows with a date field in this period but also all the blank rows.

How can I do that ?

Thanks in advance for all the help

Upvotes: 0

Views: 5475

Answers (1)

mkRabbani
mkRabbani

Reputation: 16908

If you are using "Between" mode for a date slicer, Its always required 2 parameter Start and End date as shown in the below image-

enter image description here

As a result, you can not include NULL values inside a date range as NULL is not a date. But, if you use "Dropdown" mode for the date slicer - you will get the option of including NULL values as well in the list. You need to make Multi selection option on to select more dates from the list. You can select NULL + All dates from the range you wants to set as date range (as shown in the below image)

enter image description here

Note: Definitely its a worst solution in case of bigger date range.

Upvotes: 0

Related Questions