Forum Discussion

JWorthy's avatar
JWorthy
Advocate I
8 years ago
Solved

Filter always on

Hello,   I've run a survey which has 5 questions. The questions have different answer options. I've created a slicer so the charts will show just answers from a single question.   I don't want th...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi JWorthy,

     

    Don't know if you are using measure to create your charts, but one way would be to wrap your measure around an error clause so that if people select more tha one option in the slicer it give error and no result on the chart something like this:

     

    Count answer =
IF (
    DISTINCTCOUNT ( Table[Slicer] ) <> 1;
    ERROR ( "Onle one value per slicer" );
    [Measure]
)

    This will give you an empty chart.

     

    Regards,

    MFelix

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Hmm, one way would be to put a 100% transparent rectangle graphic over top of the slicer. Impossible to click the slicer without removing the rectangle.

  • JWorthy's avatar
    JWorthy
    Advocate I
    8 years ago

    Hi Greg,

     

    Thanks for the suggestion. I'd still like users to be able to switch between 5 different filters. The trouble is when they remove all of the filters and the graph gets messed up (it effectively becomes meaningless) as in the first image.