filter by visual only works if the visual contains multiple columns from different tables?

[jch]

How come the List of Descriptions filter only works on the readin filter if I include a variable from the readin table? How do I configure the visual to filter down everything on the page listing only fields from List of Descriptions?

In readintable, 

- concatenated 2 fields to create field UniqueKey.

- readintable[CSI Description] contains a comma delimited list of strings.

In Individual Descriptions

- created by reference from readintable.

- also concatenates the same 2 fields to create a UniqueKey.

- readintable[description] is exploded by it's comma delimiter into multiple rows to create individual rows in  Descriptions[Descriptions]

From the screenshot below, UniqueKey is the relationship between the 2 tables 

Thanks in advance

[v-janeyg-msft]

Hi, @jch 

You seem to be using the uniquekey in the bbs table, which is only related to readintable. You need to change the field on the slicer to the uniquekey in the readintable table.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jch]

@v-janeyg-msft I appreciate your feedback. I might be misinterpreting your solution. 

Below is a screenshot describing the results of adding the UniqueKey from the readin table to the Individual BBs filters:

1. The idea is to filter the visual for readin[List of BBs] by the visual for Individual BBs[List of BBs]
2. I added UniqueKey to the Individual BBs filter and it still does not filter the readin visual

Much appreciated!

[v-janeyg-msft · Accepted solution]

Hi, @jch 

In a one-to-many relationship, you can only filter the relationship by table like table2, but not vice versa.

So you need to put the readintable field in the slicer, whether it is BBS or description.

You also don't need to put two fields from different tables in the slicer, it will cause problems. If you want to filter the readintable data, just use its field directly.

Hope you can understand what I said, If it doesn't solve your problem, Please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.