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

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
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

Quentin's avatar
Quentin
Icon for Helper IV rankHelper IV
6 years ago

Like joshcomputer1  and other that have comented, 
this tecniques works for some vizuals but not for others, i'm able to put the measure in the filter pane section for the other vizuals but i cannot click or edit it, it seems block and i don't understand why...

Did anyone got why?