HELP! Power BI Permutation Problem

[PowerBIJR]

Kudos to all power BI Professional, need some help here.

I have 2 tables:

1 tables contain a column with 4 digit number say 1234

I have another table with a column that contain all the permutation of number 1234 such as 1234,4321,2341,4123,3142,2143 and so on.

What i'm trying to achieve here is when i select the slicer value to 1234
Another visual will suggest all the related permutation 234,4321,2341,4123,3142,2143 so that i can pick each of them and display it on a visual bar chart, instead of me loccate individually what are the permutation of 1234.

Any suggestion that are able to check the related permutation solution is much appreciated! 

[PowerBIJR]

Hi Johnt75, this seems like a good idea but i how do i perform the matching value ?

<Index Table>               Permutation1 Permutation2 Permutation3

1234                                     3412                3124              2314                   

this should be the result for the solution you're suggesting but since i have 2 seperate table for the index table and permutation value, i couldn't find a way to match the value and compute such a table as suggested, any idea ?

[johnt75]

In Power Query select the index column and then choose "unpivot other columns" so you are left with a table like

Index column	Permutation
1234	3412
1234	3142
1234	2314

You then set up a one-to-many relationship from your main data table to this new table and put the permutation column from this table into your visuals. 

[johnt75]

Transform your data so that instead of having an index value and a list of comma separated permutations you instead have a row for each index value & permutation combination. Then you can just link the slicer to the index column and that will display all the combinations.