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

MFelix's avatar
MFelix
Super User
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

  • JWorthy's avatar
    JWorthy
    Advocate I
    8 years ago

    Hi MFelix,

     

    This sounds promising. I'm not using a measure unfortunately, pretty new to this, so I wouldn't be sure how to build the chart using a measure and then use your suggestion.

     

    Is there a way to work it into a chart I've created from the standard click and drag options?

     

    Thanks!

    • MFelix's avatar
      MFelix
      Super User
      8 years ago

      Hi JWorthy,

       

      This is not possible using only the point and click options.

       

      Believe that you want people to have additional filter options otherwise you would not place the slicer on your report.

       

      I would suggest to create a calculated measure to make the report results, and then wrapping it around the error message.

       

      If you need any help is needed please tell me.

       

      Regards,

      MFelix

       

       

      • JWorthy's avatar
        JWorthy
        Advocate I
        8 years ago

        Hi MFelix,

         

        Would you be able to direct me to a tutorial or some simple documentation that would show me how to create a calculate measure to create a chart?

         

        Thanks very much for your help.

         

        JWorthy