Advanced Slicer help!

SGK1228 — Wed, 05 Oct 2022 14:01:29 GMT

Hi, I have data that I want a unique solution to, and it is quite a challenge. Here is the dilemma:

I need to filter out the "Duplicate" ID values to only show a consolidated view as in below;

I need to remove the "Column for slicer" column in the end to show ID and key ONLY.

I cannot simply put "Column for Slicer" in the slicer of my visualization because it would not properly function to display ID of "2" when selecting filter A.

ID Key ~~Column For Slicer~~

1 A A

~~2 A+B A~~

2 A+B B

3 B B

4 C C

Can anyone help with this?

Re: Advanced Slicer help!

Anonymous — Thu, 06 Oct 2022 02:47:14 GMT

Hi @SGK1228 ,

What's your expected result when the slicer select A? Whether the below screenshot is what you want? If no, could you please provide more details on it? Thank you.

Best Regards

topic Re: Advanced Slicer help! in Developer

Advanced Slicer help!

Re: Advanced Slicer help!