Forum Discussion
Solved
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...
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.
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.