Forum Discussion
Slicer for overlapping groups - need help
Hi McSarah ,
I'd like to suggest you 'unpivot columns' on your category fields, then you can write measure formula to simply looping these fields and compare with tags.
Regards,
Xiaoxin Sheng
Thank you Xiaoxin. Can you tell me: could the series of operations necessary to unpivot dynamically adjust to future changes or additions to the series of tags used? I assumed it would not and I anticipate future changes to the list. This is why I hoped to handle this case with a formula.
Otherwise, yes, your solution would work and I may end up there anyway.
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.
