Powerbi : slicer on date but with blank

Question

I am having a table with data with one of them in the data is date format and some rows have a blank date. I want to use a data slicer to show rows in a period

How to show that?

Answer 1

Use a Between mode for date slicer and It requrieds two parameters Start and End as shown in the image below

In the result you cannot include null and date range null is not in the data,If you want to use "Dropdown" for the slicer you need to get null value as well

Do you wish to learn Power BI? Do check out how you can become a Power BI Developer from this blog.

Get an introduction to Power Bi by checking out the following youtube link: