Platform

 View Only

 Search blank in Compact slicer

Jump to  Best Answer
  • TBMStudio
Apptio Community Member's profile image
Apptio Community Member posted 10/25/21 11:57 AM
Compact slicer allows a maximum of 250 filters, and we can use the search bar to search more.
Question: If I have blank values for this field and I need to search for blank values, how can I search them?


#TBMStudio
Ken Haniu's profile image
Ken Haniu posted 10/26/21 01:54 AM  Best Answer
My solution was to use a formula to replace blank values with the word "BLANK" so that it would appear in the slicer.

I'm interested to hear if anybody has come up with anything else.

Regards,
Ken
#TBMStudio
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted 10/26/21 02:12 AM
Another Twilight Zone case again. I have tried many options, to no avail.
I have tried with a smaller list and the slicer does not display options for blank rows, it only has the non-blank values.
I suspect it just doesn't work.
I'd try adding the column to the data. Sometimes we can't do that, especially if we already have a drill-down query from two other objects. 
I'll see what experts have to say about this, @Saaraunsh Rege.​​
#TBMStudio
Apptio Community Member's profile image
Apptio Community Member posted 11/10/21 02:44 PM
@Guillermo Cuadrado did you get any updates from teh Experts? ​
#TBMStudio
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted 11/11/21 03:24 AM
I think that the solution proposed by @Ken Haniu is workable.
I'd create an additional column with a formula such as =If(data_column="","BLANK",data_column) and then would set up the slicer on this new column in the report.​ 
@Saaraunsh Rege​​
#TBMStudio
Justin Hazelrigg's profile image
Justin Hazelrigg posted 11/12/21 12:38 PM
I screen grabbed this from a presentation. Useful in these type of scenarios

#TBMStudio

Related Content