Forum Discussion
Solved
One filter for multiple fields?
Hi.
In my report I would like to have the possibility to filter (slicer) on the priority fields. For example, if I select Priority 1, my list should consist of all cases. If I select Priority 2, only case 1 and 2 should be included. Even though the filter is in Desktop, I assume I should make a new field (DAX) or? How can I solve this?
| Case | Name | Prio DK | Prio SE | Prio NO | Prio FI |
| 1 | Test 1 | 1 | 2 | ||
| 2 | Test 2 | 2 | 1 | 3 | |
| 3 | Test 3 | 3 | 1 | ||
| 4 | Test 4 | 3 | 1 |
Thanks a lot in advance.
Br. Helen
You could unpivot the Priority columns in Power Query:
= Table.UnpivotOtherColumns(#"Changed Type", {"Case", "Name"}, "Priority Type", "Priority")= Table.UnpivotOtherColumns(#"Previous Step", {"Case", "Name"}, "Priority Type", "Priority")giving a table like this
You could use a matrix visual to get your desired outpt
2 Replies
You could unpivot the Priority columns in Power Query:
= Table.UnpivotOtherColumns(#"Changed Type", {"Case", "Name"}, "Priority Type", "Priority")= Table.UnpivotOtherColumns(#"Previous Step", {"Case", "Name"}, "Priority Type", "Priority")giving a table like this
You could use a matrix visual to get your desired outpt
It worked - thanks a lot.
Br.
Helen
