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

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

Hi everyone,

I wrote a comment because this technique was working but only on some visuals and not on everything. So i applied another technique transforming my variables in Measure that are calculated based on a fact a filter is selected and use this measure in the visualisation, not the variable filtered on a measure.

In my case i want the table Metrics to be filtered on one and only one metric and show the progress realised in the table Progress Report:

SelectedProgress = If(calculate(distinctcount(Metrics[Title]);ALLSELECTED(Metrics[Title]))=1; CALCULATE(Sum('Progress Report'[Progress]);ALLSELECTED('Progress Report'));Blank())

Seems to work fine for my necessities, cannot assure it solves all problems