how to create a slicer to filter a pivot table in visual to filter blank values in multiple columns

[ranjan1701]

Hi,

I have a pivot table visual  something like this in my Power BI report :

Issue Id	Issue Desc	Reported Date	Assigned Date	Work Started Date	Work completed date
1	Netwok fail	01/01/2017	02/01/2017	null	null
2	CPU	01/03/2017	04/03/2017	06/03/2017	null
3	Intranet	01/02/2017	03/01/2017	04/01/2017	06/01/2017
4	Hardware	01/04/2017	null	null	null

I want a slicer so that user can filter out table containing null values in different date columns. (*only one slicer)

Can anyone give idea how to achieve that ?

Thanks in advance 

[dilumd]

Hi,

You can create a new column using IF and ISBLANK function and the use it as a slicer. (if the behavior is the same as above data set you can use below function)

Remember you have to create a column if you want to use it as a slicer.

Blank = IF(ISBLANK(SlicerHelp[Work Com Date]),"Blank Raws","Non Blank")

[ranjan1701]

Thanks for your suggestion.In this way, I have to add different slicer for each column, but I am looking for a way to include all the columns in same slicer for filtering.

[dilumd · Accepted solution]

Hi,

If so you can use this formula,

Blank New = IF(ISBLANK(SlicerHelp[Assigned Date]),"Assign Date Blank",IF(ISBLANK(SlicerHelp[Work Started]),"Start Date Blank",IF(ISBLANK([Work Com Date]),"Comp Date Blank","Non Blank")))