make slicer for multiple columns with binary data structure?

[Anonymous]

hi, I have columns that correspond to a region coded like below, and would like a slicer that would have this structure

Filter by region:

Northeast
Midwest
South
West
National
Other/Not specified

How would I go about doing this if the values are true/false?

Northeast	Midwest	South	West	National	Other/Not specified
FALSE	FALSE	FALSE	FALSE	FALSE	TRUE
FALSE	FALSE	FALSE	FALSE	FALSE	TRUE
TRUE	FALSE	TRUE	FALSE	FALSE	FALSE
FALSE	TRUE	TRUE	TRUE	FALSE	FALSE
FALSE	FALSE	FALSE	FALSE	TRUE	FALSE
FALSE	TRUE	FALSE	TRUE	FALSE	FALSE

[Anonymous · Accepted solution]

I figured out that I just needed to unpivot the columns https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882... 

[v-yanjiang-msft]

Hi @Anonymous ,

Sorry I'm not very clear about your expected result, do you want to get a table contains all the above column names?

Then filter the columns by the column name slicer?

Best Regards,
Community Support Team _ kalyj

[amitchandak]

@Anonymous , the second table should have some columns in the row.  seems incomplete

[Anonymous]

Hello, I just have this one table as an example:

Northeast	Midwest	South	West	National	Other/Not specified
FALSE	FALSE	FALSE	FALSE	FALSE	TRUE
FALSE	FALSE	FALSE	FALSE	FALSE	TRUE
TRUE	FALSE	TRUE	FALSE	FALSE	FALSE
FALSE	TRUE	TRUE	TRUE	FALSE	FALSE
FALSE	FALSE	FALSE	FALSE	TRUE	FALSE
FALSE	TRUE	FALSE	TRUE	FALSE	FALSE