One filter for multiple fields?

[HEW]

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

[PaulOlding · Accepted solution]

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

[HEW]

It worked - thanks a lot.

Br.

Helen