Forum Discussion

vishy0501's avatar
vishy0501
Helper I
7 years ago

Slicer for column with multiple values

Hi ALL, Greg_Deckler  Kindly request you all to help me with this scenario -    Hi All, So the requirement is as follows - Dim table value Column 1 A B C Fact Table Sales Column2 10 A+B ...
Need Help
Tips and Tricks
belisqui's avatar
belisqui
Advocate IV
7 years ago

Can I suggest creating a manual table in the module with the values below then you create a many to many relationship to the fact table.

 

You link the key to the fact table, and use the second column in your slicer.

Key        Column For Slicer

A                  A

A+B             A

A+B             B

B                  B

C                 C

 

Let me know if this works.

SGK1228's avatar
SGK1228
New Member
3 years ago

This is exactly what I need, BUT I also need to filter out the "Duplicate" ID values to only show a consolidated view;

 

I also need to remove the "Column for slicer" column in the end to show ID and key ONLY. Any ideas community?

 

ID    Key        Column For Slicer

1         A                  A

2         A+B             A

2         A+B             B

3          B                  B

4          C                 C