topic Enable visual interaction without relationship in DAX Commands and Tips

Enable visual interaction without relationship

Dimitris_Kats — Fri, 17 May 2024 16:38:07 GMT

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 have added accounts and in the bar chart products. There isn't an active relationship between the two tables( it can't be created) so when I click on a bar the mayrix remains the same. I need the bar chart and the matrix to interact.

Is there any way to achieve that with a measure?

Re: Enable visual interaction without relationship

mark_endicott — Fri, 17 May 2024 16:58:57 GMT

Dimitris_Kats - You can perhaps make use of TREATAS or INTERSECT in a measure to create a virtual relationship.

Review this article and see if it works: https://www.sqlbi.com/articles/physical-and-virtual-relationships-in-dax/

If this helps, please mark it as a solution.

Re: Enable visual interaction without relationship

Dimitris_Kats — Fri, 17 May 2024 18:42:00 GMT

Thank you so much mark_endicott I have already tried the inactive relationship and the treatas without the desired results 😔

Re: Enable visual interaction without relationship

Dimitris_Kats — Fri, 17 May 2024 21:12:21 GMT

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??

Re: Enable visual interaction without relationship

Dimitris_Kats — Sat, 18 May 2024 12:30:54 GMT

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!!!

Re: Enable visual interaction without relationship

xifeng_L — Sat, 18 May 2024 13:55:24 GMT

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~

Re: Enable visual interaction without relationship

Dimitris_Kats — Sat, 18 May 2024 15:52:50 GMT

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!!!

Re: Enable visual interaction without relationship

xifeng_L — Sat, 18 May 2024 16:36:13 GMT

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.

Re: Enable visual interaction without relationship

Dimitris_Kats — Sat, 18 May 2024 16:50:34 GMT

That makes sense. Thank you so much for the thorough explanation 😃

Re: Enable visual interaction without relationship

Buddy_TX — Thu, 09 Jan 2025 16:53:42 GMT

xifeng_L

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!

Re: Enable visual interaction without relationship

Buddy_TX — Thu, 09 Jan 2025 18:28:25 GMT

xifeng_L I just renamed to remove the "zip" extension and it opend in PBI. Seems like it was not a zipped file instead it was a pbix file with zip file extension. Now, can you please walk me through the logic & solution? I am new to these advance techniques. Thanks!