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

RAHEEL's avatar
RAHEEL
Icon for Helper I rankHelper I
8 years ago

Excellent...that really helped...BUT where I have only one value in the SLICER Table it always reutrn the slicercheck to Y. Is there a way to get the same functionality with just one value in the slicer.

 

e,g, I have only one value. "SHOW' in the slicer and when the user select/clicks show on slicer only then it should display the data on visual and when the user deselect the SHOW on slicer it should reset the data. like I am trying to get the toggle button functionality from this.  Thanks

 

 

Regards,
Raheel

joshcomputer1's avatar
joshcomputer1
Icon for Helper V rankHelper 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
    Icon for Helper V rankHelper 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!