Forum Discussion

Dave0145's avatar
Dave0145
Frequent Visitor
9 years ago
Solved

Visualisations blank until something selected in a slicer

The default functionality for a slicer in Power BI seems to be that if nothing is selected in a slicer then all records are shown in visualisations on the same report where the interactions are set a...
Custom Visuals
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Dave0145,

     

    For your requirement, you can create a measure like this:

     

    SlicerCheck = =if(calculate(distinctcount([SlicerColumn]),allselected([SlicerColumn]))=1,"Y","N")

     

    Then place this measure in a table visual, set filter condition as is Y. If you want to select multiple values in a slicer, set is N.

     

    For more information, see:

    Empty table with a slicer

    visual filter problem--unpredictable behavior

     

    Best Regards,
    Qiuyun Yu

joshcomputer1's avatar
joshcomputer1
Helper V
8 years ago

RAHEEL

 

Maybe the slicer needs to be single select? When nothing is selected, it should work the same as a list with many options. I would test your measure on a card to see if when the slicer is used or not used, the card will switch.  This functionality is sketchy. I never got it to fully work as intended with all measures. I wish there was a field in the controls to just "when nothing selected" display this "".

joshcomputer1's avatar
joshcomputer1
Helper V
8 years ago

Hi NWBI,

 

 I don't know if what you are trying to show is a measure or not, but if there is a DAX formula for it, then you can use the expression hasonefilter as a conditional statement (similar to iserror in excel) so you can set it to zero if no filter. I am sure you can type the word "Blank" and it will display, but not sure if you place "" it will actually be blank. Worth giving it a shot. 

  • NWBI's avatar
    NWBI
    Frequent Visitor
    8 years ago

    Just added Slicer Check as a tooltip on the charts I wanted to blank out, and it let me filter OK, 

     

    Thanks!