Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)
edited by
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?

1 Answer

0 votes
by (22.5k points)

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

enter image description here

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

enter image description here

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: 

Related questions

0 votes
1 answer
asked Dec 26, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
asked Mar 4, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Feb 10, 2021 in BI by Chris (11.1k points)

Browse Categories

...