topic One filter for multiple fields? in DAX Commands and Tips

One filter for multiple fields?

HEW — Thu, 11 Nov 2021 13:25:07 GMT

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

Re: One filter for multiple fields?

PaulOlding — Thu, 11 Nov 2021 16:47:46 GMT

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

Re: One filter for multiple fields?

HEW — Fri, 12 Nov 2021 09:37:05 GMT

It worked - thanks a lot.

Br.

Helen