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 (not filtered)
    • Client number
    • Transaction type
    • More details...

 

I've configured an interaction between visual A and B. I want to select a client from Visual A to see the details from this client in Visual B. When I select a client from A it brings only the transaction X and Y to Visual B. However, I would like the interaction to only be on the cilent number and not on the transactions (B should display all transactions from the selected client).

 

How to acheive this?

 

Thank you,

David

Need Help

2 Replies

  • 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