Filter Table visual

[Julian_H]

Hi,

I have data where I have three section fields where a sales adviser can be attributed to. They could be ibn all 3 or 2 or just one or none.

I am trying to visual the data a sales adviser is linked too from the sections , sorry to ask but how can you filter this.

Example

Section 1 = John D

Section 2 = Jane C

Section 3 = John D

So if the user selects John D from the slicer they would see every client that he is contected to

Thank you

[Julian_H · Accepted solution]

Hi

I have resolved the issue I had , bit of a faff, but set up a new table unioned the data together to get one column showing the sections then summarised it.

All works ok but as said seems a bit of a long way round

[Julian_H]

hi, using the following adviser a2 is involved with this client so I would need to be able to see thses details when filtering by a slicer, however currenlty when I filter I wouldnt see the data as it is only picking up section 1 who is a1. So what I am trying to acheive is to have a table that when you use a slicer for an adviser you get a result that shows all the clients they are connected with not just if they are in section 1. I hope this explains it, I cant send actual data as it is sensitive

[Fowmy]

Hay@Julian_H 
Can you share some sample data with the desired output to have a clear understanding of your question?
Mention whether you want a calculated column or measure.
You can either paste your data in the reply box or save it in OneDrive, Google Drive, or any other cloud-sharing platform and share the link here.