Forum Discussion
Slicer for overlapping groups - need help
Hi McSarah,
In power query, 'unpivot column' function only requires you to set the category column and unpivot two column names.
So if your category column does not been modified, you only need to refresh your source table and these new group fields will also append into unpivot columns.
Notice: I remove the auto-generated 'change type' step(after PromoteHeaders step) to prevent 'key not match' issue that caused with power query 'cache previous data structure' mechanism and manually do it after 'unpivot columns' steps.
Regards,
Xiaoxin Sheng
I expect to need to modify the cateogories, add additional categories, etc. This is the reason I wanted to avoid unpivot. I think that unpivot is likely not the best solution since I think it will require more rework than I want to do.
Since I need the categories and groupings to be more flexible, I think I will need to stick with standard groupings and sacrifice overlapping categories until the categories are more fixed.