on 20 Jan 2016 07:23:34
A property called "Mandatory select" would be nice under "Selection Controls" for the slicer. This would enforce filtering if the underlying dataset is very big. At least one value must be selected at all times if this property is turned on.
- Comments (48)
RE: Slicer mandatory selection property
Yes this is needed in the case where you have data that if not filtered doesn't present usable data
RE: Slicer mandatory selection property
This is almost a requirement for some of the work that i have been doing relating to Sales Executive Dashboards, I want to look at just one Sales Exec at a time, it makes no sense to see all the information for all opportunities on a page specifically designed for an individual break down.
RE: Slicer mandatory selection property
Again, its unbelievable this is not available. Also when you de-select 'Select All' the system should not retrieve any data at all.
RE: Slicer mandatory selection property
I am currently assessing Power BI as an alternative to an interactive excel worksheet but not having this option has limited the applications usefulness.
RE: Slicer mandatory selection property
I actually wrote a custom slicer visual that's doing just that(Selection is mandatory and if one is not present, a default selection will be made), but the recently-enabled sandboxing feature wreaked havoc upon it and rendered it useless(beyond repair). Therefore, I truly hope this idea would be implemented.
RE: Slicer mandatory selection property
Should be quite simple to add this to the "Selection Controls" section of the format properties.
RE: Slicer mandatory selection property
Exactly what I am looking for!
RE: Slicer mandatory selection property
YES