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
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