Matrix - Report

[Anonymous]

Hi, I'm starting to use Power Bi, still learning so I'm a pre-basic user (not even basic yet).

But I do need help on building a report/dashboard so I can have a graphic visualisation of a matrix. I work at an audit firm and I have a big matrix with all the auditors in one column and all the clients they audit in other columns.

I wanted to build a report where I could choose the auditor and it would show me which clients they audit and the other way around by selection the client and seeing which auditors work on this selected client.

The matrix looks somewhat like this:

Any clues? I tried changing the X for the name of the auditor. For the name of the client... but I can't get the results I want.

[Cmcmahan]

How are your data tables set up?  How is an Auditor linked to/related to a Client?

Once we know how your data is set up, we can give you better advice on how to display it.