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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

v-qiuyu-msft - great solution, thanks! +1

 

I did note that if you bring the measure onto a table as a column, then the calculation slows down considerably, so best to have it only on the visual level filter.

 

I noted also that you can't have it on the Page level or Report level filter, but you can of course drag it onto the visual level filter for other tables.

AnetaK's avatar
AnetaK
Icon for Helper V rankHelper V
9 years ago

Hello,

 

I've used this solution to hide a claster column chart and it works.

I've also tried to hide a card with text inside but the visual filter is not working, I can't choose anything, it's blocked.

Can anybody suggest what can be done in that situation?

Is it impossible to use a measure-filter in a card?

 

What I want to achieve?

I want the card to be invisible until a room on a visual is chosen.