Display (text) table filtered by 2 criteria, each from different tables

[Anonymous]

I have some data that I want to categorise by assigning a number between 1-5 to each row. (Leaving blank is also valid)

It's possible that some rows will belong in more than one catergory, so I have 2 category columns A and B.

 

What I want, is a way to filter the data by category (1-5) by considering both columns. 

e.g. I slice by catgeory 5 and see Row 1 and Row 5 returned.

I'm having no luck figuring out the best way to do this, so any help would be appreciated.

Thank you!

[alexei7 · Accepted solution]

Hi @Anonymous,

Presuming you source data look like your screenshot below, I would "unpivot" the data:

- Go to Power BI query editor

- Go to the "Transform" menu

- Select the Category A and Category B columns

- Click "Unpivot Columns"

This should give you something like the below, which will enable you to filter on "Value" and see the rows which have either Category A or Category B with the value you filter on.

Hope that helps

Alex

[Anonymous]

@alexei7 That's perfect and much simpler than any of my ideas. Thanks.