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

vega's avatar
vega
Icon for Resolver III rankResolver III
8 years ago

I'm not quite sure how this solves the problem. I thought I had a similar problem to OP. I need to have a table that is blank until someone selects something in the slicer (one or more values). This solution works fine for a slicer when multiple values cannot be selected. But when multiple values are selected, it does not work.

 

The formula is checking if there is one value selected. If we select one value this is fine, but multiple selected values are treated the same way as no value selected, this is where the problem is.