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

joshcomputer1's avatar
joshcomputer1
Icon for Helper V rankHelper V
8 years ago

So it's counting based on the grouping of the values rather than the distinctcount of dates? Can you use allexcept() in your measure and put the groupings name in there so it won't point to that element? Might be worth a shot. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hm... I tried 

 

Date Filtered = calculate(DISTINCTCOUNT('Data'[Date]),ALLSELECTED('Data'[Date]),allexcept('Data','Data'[Date]))

But it behaves the same way.