Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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!
Solved! Go to 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.
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.
Please show the expected outcome based on the sample data you provided, and the slicer selection.
User | Count |
---|---|
85 | |
82 | |
66 | |
52 | |
48 |
User | Count |
---|---|
100 | |
49 | |
42 | |
39 | |
38 |