Olaf Schroeder on 31 Mar 2023 13:58:46
Slicer selection import values from excel or CSV for Multi-select slicers. Competitor products have for some time had the ability for a user to default a Multi-select slicer selection by importing a list of values from a single column CSV or Excel file they already have. There is no active link to the upload source, it is just a one-time use to default the current slicer selection. Aside from the defaulting of the Multi-select slicer selection, there is no change to existing behavior of the slicer Multi-select slicer from that point forward.
Benefit:
Saves frustration of the business user making a long list of multiple value selections by allowing them to use a pre-verified CSV or Excel source as a one-time import to default the slicer.
Justification:
This is necessary to enable better self-service where business users need to default the selection of a slicer from an external source they have rather than them having to manually select these same list of values from the dropdown.
Secondly, this helps advanced uses who develop their own bookmark navigator bookmarks to default Multi-select slicer selection values to have a way to initially populate the selection of a single Multi-select slicer.