Forum Discussion
make slicer for multiple columns with binary data structure?
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 specif...
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-f588221c7098
Anonymous , the second table should have some columns in the row. seems incomplete
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 |