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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

What would the work around be for a Measure, not a column?