Forum Discussion
Filter Table visual
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
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
3 Replies
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
HayJulian_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.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
