Grouping states in slicer

[pat1214]

Hello,

I have a field in my table called 'Location' which has different US states, US Territories and International. I created a slicer for 'Location' so the end user can view student enrollments by different states etc. I need to be able to group all the states under 'States', if it is a US Territory, then 'US Territory' else 'International'. So essentially in my slicer, I will have just 'states', 'US Territories' and 'International'. 'States' would drop down to show selections for all 50 states. Hope this makes sense! Picture 1 is how the field in the table looks like. Thank you!

[Anonymous · Accepted solution]

HI @pat1214 ,

Unfortunately, you can't direct grouping your data in the slicer.
I'd like to suggest you add a custom column with switch function or if statement to manually setting groups for your records. Then you can use them to create a hierarchy field and use it in custom visual hierarchy slicer.

How to create and use a Power BI Hierarchy 

HierarchySlicer 

Regards,

Xiaoxin Sheng

[JosefPrakljacic]

Hey @pat1214 ,

you switch to the Power Query Editor (by pressing edit queries).

There you add a new "Conditional Column" where you write the conditions you have described here.

Then you put the new created column into your slicer.

Finito

If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others

Have a nice day!

BR,
Josef
Graz - Austria