The visual table must be filtered by a field that must not appear in the table.

[NewPBIe]

I have a visual table with columns from fields A, B, C and a pie chart that is based on field D.

All fields are from a single Data Table (A B C D).

Is there a possibility to filter the table by the field D by clicking on the pie chart without having to show the field D in the visual table?

[NewPBIe]

Hi @Arul thank you for your answer. I looked and The field D is actually on another Table - how can I manage that?

[Arul]

@NewPBIe ,

Can you share the relationship between the tables what they have?

Thanks,

Arul

[NewPBIe]

Sure, it is Table A:Table B = 1:*

Table A holds Fields A, B, C

Table B holds Fields A, B, C, D

Table B is a copy of Table A, where a multivalue column was splitted in rows and transponed.

[Arul · Accepted solution]

@NewPBIe ,

You have to use A,B,C columns from table in your visual so that when you slice pie chart table visual values also get filtered. (or) Set the relationship between tables as both.

Thanks,

Arul

[NewPBIe]

I can't use Table B, because all my other visual are basing on Table A.

With the "both" directions relationship works. Thank you!

[Arul]

@NewPBIe ,

Yes. Because fields A, B, C are also lying on the same table where D comes from.

Thanks,

Arul