Forum Discussion

Dimitris_Kats's avatar
Dimitris_Kats
Helper V
2 years ago
Solved

Enable visual interaction without relationship

Hello dear members. I need your help.   I have a matrix and a bar chart. The matrix and the bar chart uses the same measure in the values but in the rows they use different fields. In the matrix I...
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    Hi Dimitris_Kats ,

     

    In your scenario, the best option would be to implement this using the calculation group, rather than using the USERELATIONSHIP.

     

    The effect is shown below.

     

     

     

     

    Demo - Interactions.pbix

     

     

     

    Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

     

    Thank you~

     

     

Dimitris_Kats's avatar
Dimitris_Kats
Helper V
2 years ago

So I was able to make progress after all by using the " USERELATIONSHIP" . I created one active and one inactive relationship with the table and I was able to display the data on the bar chart. So when the first level of the category is being filtered I use the active relationship and when the second level of the category is being filtered I display the data based on the inactive relationship. 

The only problem now is that the second level of category in the bar chart can cross filter the other visuals. I suppose this is due to the inactive relationship. Is there any way to fix this??