Forum Discussion
Create list based on multiple columns
Naturally, that would happen, if you unpivot.
The reason, I'm asking, is that there is no intuitive way to slice the original table like you are asking for unless you create all the possible combinations of the 3 columns. That can be done in 2 ways (as I see it). Either unpivot or create all the combinations with a concatenate function (which, I think, is a very clumsy method). Either way, your database will grow in size. Unfortunately, I'm not familiar with any convenient way to slice like you are asking for.
Hi Martin,
Thank you for all your help. Though not the outcome I hoped for at least now I know there are no alternate solutions.
KR,
Sander
Hi Sander800
If I understand your challenge correctly, you'd like a hierachy slicer. There is a great custom visual for this purpose, which is called "Hierachy Slicer". You get it by looking for the "From Store" button in the menu under the headline "Custom Visuals". See screenshot below.
If this doesn't accommodate your problem, let me know, and I will try to help you solve the problem.
Best,
Martin
Hi Martin,
Sorry for the late reply. I am aware of the hierarchy slicer, quite a nice visual (though too slow for large hierarchies).
I am actually not looking to see this in a hierachy. I am trying to get (manually) selected values from different columns in 1 flat list/ slicer.