Forum Discussion
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...
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
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