Forum Discussion
Matrix sliced by multiple columns
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!
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.
3 Replies
Please show the expected outcome based on the sample data you provided, and the slicer selection.
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.
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.
