Filter tables values of a columns filtered in field parameter slicer

[mscla]

Hi for everyone!

I'm looking for a way to do this.

I looked in several posts here and couldn't find it.
my main table has 6 columns that indicate the possible priority of lots in which each sale (key) may belong to certain vendors.

KEY	JOHN_ANA_PETER	JOHN_PETER_ANA	PETER_ANA_JOHN	PETER_JOHN_ANA	ANA_PETER_JOHN	ANA_JOHN_PETER
10255434	ANA	ANA	ANA	ANA
10256107	ANA	ANA	ANA	ANA	ANA	ANA
10260048	JOHN	JOHN			ANA	JOHN
10258289	ANA	ANA			ANA	ANA
10253959	PETER	PETER	PETER	PETER	PETER	PETER
10256459	ANA	ANA	ANA	ANA	ANA	ANA
10251625	PETER	PETER	PETER	PETER	PETER	PETER
10256807	JOHN	JOHN	ANA	ANA	ANA	JOHN
10256349	ANA	ANA	PETER	ANA	ANA	ANA
10252767	ANA	ANA	ANA	ANA	ANA	ANA
10255534			ANA	ANA	ANA
10250133			JOHN		ANA
10253187	ANA	ANA	JOHN		ANA	ANA
10256974	ANA	ANA	ANA			ANA
10255843
10251743	PETER	PETER	PETER	PETER	PETER	PETER

I created a Field parameter in power bi that allows the user to choose which of the 6 columns he wants as batch priority and I created calculated columns that define each batch, it looked like this

Parameter	Parameter Fields	Parameter Order	lot1	lot2	lot3
JOHN, ANA, PETER	table[JOHN_ANA_PETER]	0	JOHN	ANA	PETER
JOHN, PETER, ANA	table[JOHN_PETER_ANA]	1	JOHN	PETER	ANA
PETER, ANA, JOHN	table[PETER_ANA_JOHN]	2	PETER	ANA	JOHN
PETER, JOHN, ANA	table[PETER_JOHN_ANA]	3	PETER	JOHN	ANA
ANA, PETER, JOHN	table[ANA_PETER_JOHN]	4	ANA	PETER	JOHN
ANA, JOHN, PETER	table[ANA_JOHN_PETER]	5	ANA	PETER	JOHN

Now, how do I link the parameter with the table so that it filters the keys based on the applied filter

For example, if the user selects the parameter "JOHN, ANA, PETER" the visuals will bring the following?

lot1

KEY	Vendor
10250133	JOHN
10253187	JOHN

lot2

KEY	Vendor
10255434	ANA
10256107	ANA
10256459	ANA
10256807	ANA
10252767	ANA
10255534	ANA
10256974	ANA

lot3

KEY	Vendor
10253959	PETER
10251625	PETER
10256349	PETER
10251743	PETER

sales_parameter_filter.pbix 
thanks

[mscla]

It's working perfectly, thanks @Anonymous 

[Anonymous · Accepted solution]

Hi @mscla ,

Based on my testing, please try the following methods:

1.Open the power query editor. Duplicate the table and unpivot columns.

2.Drag the field into the matrix visual.

3.Create the new measure to filter the values.

Vendor john = 
VAR value_ = SELECTEDVALUE('Unpivot table'[Value])
RETURN
IF(value_ = "JOHN", 1, 0)

4.Drag the measure into the Filters pane and enter the show items is 1.

5.The result is shown below.

6.Repeat the above and the result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.