Matrix sliced by multiple columns

[SebastianGP]

Hi guys,

I've been having a problem in creating a report containing a matrix with min/max values.

I would like the matrix to display the min/max run times of a particular section based on the choice made in a slicer (selecting between section).

The data looks aproximately like this:

Case ID	Type	Run time section 1	Run time section 2	Run time section 3	Run time section 4
Case 1	Assisted	49	55	47	96
Case 2	Self-service	31	81	18	47
Case 3	Self-service	92	83	74	85
Case 4	Self-service	26	17	55	68
Case 5	Assisted	43	61	4	96
Case 6	Assisted	66	30	77	85
Case 7	Self-service	42	0	9	24
Case 8	Assisted	51	95	73	77
Case 9	Self-service	38	91	23	100
Case 10	Self-service	40	31	78	83

So based on this data I need the matrix to spit out the top 3 values of a section run time based on a slicer. How would I go about doing that?

Many thanks in advance!

[SebastianGP · Accepted solution]

I found the solution:

Under File>Options>Preview features: check the Field parameters box and restart Power BI Desktop.

Add a new parameter based on fields

And create a Dynamic Filter containing the different fields you would like to be able to filter between.

Lastly you can create a slicer with the fields you selected in your dynamic filter. This slicer will add/remove the fields you select.

[SebastianGP]

The expected outcome would be:

Case ID	Type	Run time (based on slicer)
Case 1	Assisted	49
Case 2	Self-service	31
Case 3	Self-service	92
Case 4	Self-service	26
Case 5	Assisted	43
Case 6	Assisted	66
Case 7	Self-service	42
Case 8	Assisted	51
Case 9	Self-service	38
Case 10	Self-service	40

Whereby the slicer makes a selection between the different run-time selections.

[lbendlin]

Please show the expected outcome based on the sample data you provided, and the slicer selection.