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, on...
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
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
