Forum Discussion
Enable visual interaction without relationship
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.
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
- xifeng_LHi.
I have used your previous demo file to create a sample file to demonstrate my problem. In order to enable the interaction between the bar chart and the matrix I have created one active and one inactive relationship.As you can see in the file, if a brand is selected in the slicer, the bar chart displays the measure by model. When users click on a specific bar in the chart, the matrix is filtered accordingly(because of the active relationship). However, when no brand is selected in the slicer, the bar chart cannot filter the table. Specifically, when a bar is selected, the matrix displays blanks instead.
Without Selection:
With selection:
Please find the file in the following link:
https://drive.google.com/file/d/1nUQge8HWa5dYFRFt_P65cIiyxKQXNR8p/view?usp=sharing
Thank you so much for your valuable help!!!
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.
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
Thank you so much. This has worked perfectly!!!
Is it possible to explaine me why the calculation Group has worked and what was the problem with the inactive relationship?
Thank you so much again!!!To avoid the filtering of auxiliary tables affecting the calculations of other tables, it is therefore preferable to disconnect the relationship.
Calculated groups are used in order to add the filtering of selected items in the bar chart to other measure, you can check the expression for calculated groups to understand this.
That makes sense. Thank you so much for the thorough explanation 😃
I am also facing same issue. I was hoping I would download your file to learn the solution however when I exracted the zip file, I could find PBIX file. all files are without extensions and there are so many. Can you please share the pbix file with the solution and explain it also. I am relatively new to PBI :). Thanks!
