Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Visual interaction based on 1 column instead of all

Hi all,   Let say I have the following visuals in a dashboard Visual A (filtered on transaction type X and Y) Client number Transaction type  Transaction date Transaction amount Visual B (...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous ,

 

Make sure the fields dragged to two visuals do not have a physical relationship. Then you may apply virtual relationship in DAX measure and take advantage of Visual level filters.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Sam,

 

Just ot be sure that my understanding of your suggestion is correct.

 

Let's say the fields are from the same table for now... Do you suggest to create an alias for this table so that the 2 visual are from 2 tables (the original and the alias)? Would that break the physical relationship?

 

Than I could configure a DAX visual level filter so that only one field would filter the other visual even if both share more than 1 field?

 

Thank you

David