How to make slicers show in a non-hierarchical manner?

[SF_2024]

Person	Salary	City	Job	Hair Colour	Gender	Favorite Dish
James	100	Boston	Clerk	Black	Male	Hamburger
Franc	120	New York	Clerk	Brown	Male	Salmon
Cassady	140	New York	Lawyer	Black	Female	Salmon
Nathalie	150	Boston	Lawyer	Brown	Female	Hamburger

The table above is supposed to represent a very large table with far more rows and possible values. For simplicity the above one is used.

I want to summarize "Salary" and be able to slice it by "City", "Job", "Hair Colour", "Gender" and "Favorite Dish", but I don't want a heriarchy. How do I do this?

I.e. I want the slicer to look this way:

City
	Boston
	New York
Job
	Clerk
	Lawyer
Hair Colour
	Black
	Brown
Gender
	Male
	Female
Favorite Dish
	Hamburger
	Salmon

Reason for I want it this way is because there is no obvious heriarchy between the columns "City", "Job", "Hair Colour", "Gender" and "Favorite Dish", and there may be many more columns that I want to use to slice. 

[_AAndrade]

Hi,

You can create a slicer for each column and that way you don't have a hierarchy.
Example:

[SF_2024]

Thank you for your reply! A problem is that if there are like 20 factors, it takes a lot of space on your screen, which is why I tried to avoid using 1 slicer per factor. 

Is there any way to "group" the 20 slicers such that I click one drop-down that shows the 20 slicers?

I understand I could use bookmarking, but I am trying to avoid bookmarks since there is already a lot of bookmarks. 

[Anonymous · Accepted solution]

Hi @SF_2024 ,

I think you can use Field Parameter to group the slicers you want to select.

Then I use another slicer to contain the slicers you want to select.

Finally when I select any selection and the slicer will give the correct answer.

Best Regards

Yilong Zhou

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

[SF_2024]

Thank you, I think that works good enough!