Slicer - 'All' vs. 'Select All'

Power BI
1

Hi,
The native slicer (filter- multiple selections enabled) - drop down view comes with the following functionalities:

  1. when no selections are being made, then the “All” indicates - all data is being selected. – see pic 1.
  2. if I enabled “select all” options, then an additional item -“Select all” will be added. In this case, the word “All” will be all data is being selected. – see pic 2 & pic 3.

Pic 1:
image

Pic2 :
image

pic3:
image

Questions,

  1. If there is a way to disable “All” item ? - with drop down view ?
  2. If there is a way to ‘flip’ filter logic where when nothing is selected or nothing is checked in drop down, then NO DATA is selected = displays nothing ?
  3. if the native slicer can’t be configured for Q1 & Q2, other controls in market place that can support (1) or/and (2) ?

Thanks!

2

Hi akiko_lim,

For the 2nd question to display nothing when nothing is selected or nothing is checked you can use a measure like this:

Check = INT(IF(ISFILTERED(‘Table’[Column]);1;0))

You can use it in the visual filter of the table as you can see in the added image.

Knipsel

3

Thanks uriah1977. Sorry for my late reply.

I tested this out. It works. :slight_smile:

4

@akiko_lim Glad to hear it works :+1: