Intellipaat Back

Explore Courses Blog Tutorials Interview Questions

Powerbi : slicer on date but with blank

0 votes
3 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
PowerBI - Dynamic TopN + Others depending on slicer
asked Dec 26, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
PowerBI how to use one slicer with two columns (dates)
asked Jan 5, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
Time slicer in PowerBI
asked Mar 4, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
Between Date Range Filter PowerBi
asked Feb 10, 2021 in BI by Chris (11.1k points)

Browse Categories

© COPYRIGHT 2011-2024 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...