Slicer Select All vs Select None
Would be nice if when select all is enabled on a slicer that when you choose select all it shows everything in associated visualizations BUT when you de-select all the associated visualizations show nothing. At present either option shows everything.
To get around this, I have resorted to appending a special row in the table that displays " (none) " in the slicer, and has null for most all the other fields. I also have to set the slicer to "Single Select". Bit of a pain but it works.
I observe one small drawback - the y-axis grid lines shift ever so slightly when (none) is selected. If you are overlaying line charts for comparison, it looks bad.
I want to expand this a bit and say this could also be achieved by making some filters "required" which could be VERY useful anyway. Effectively they would be report prompts. Nothing happens until a selection is made. It would be very helpful in many instances to mark some filters as "Required Prompt" which would mean when NOTHING is selected, the page waits for that filter to be specified. Then set the "clear" action to "Default to All" or "Default to Required Prompt/None". Lastly, this would really help with reports that can have very LARGE result sets that people don't need to run the entire result set but a default selection isn't really a good option.
Agreed, the slicer should not return results when nothing is selected, but 'Select All' should be the default selection for each slicer (out of the box).
I like where the Anonymous comment on March 02 is going, but it would be unnecessarily tedious to apply on multiple report pages across multiple filters, and would require the developer to make sure every time the report is published, that 'select all' or every single slicer option is manually checked. Otherwise the end users would need to hunt around to discover why the report is blank - especially disconcerting on reports with multiple filters
Kenneth Wilson commented
Agreed, This should be the default behavior.
Note that without Select All showing I can achieve the desired result using a measure like this as a filter on the associated visualizations:
MySlicer = IF (
where 'MyTable'[MyColumn] is what is used for the values in the slicer.