Showing locational data in a slicer that allows multiple locations to be selected

[Anonymous]

Im reporting project data for 27 different locations in a dashbaord. My data source allows for the option to select multiple locations for each project. However, in the slicer I want only the 27 stores to be visable and not the multiple selections. Right now, the slicer shows the indivdual locations as well as the multiselect locations.

[Anonymous]

Hi @Anonymous ,
Based on your description, you have a report containing multiple items, each corresponding to a different store. However there are 27 of these stores and you want to create a slicer with 27 of them, then you only need to put the store columns into the slicer as only the data that varies from one to another will be displayed in the slicer.

If you want to make it radio selectable, you can choose to turn on this single selection option.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly