March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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?
Solved! Go to Solution.
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~
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 😃
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??
@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.
Thank you so much @mark_endicott I have already tried the inactive relationship and the treatas without the desired results 😔
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
26 | |
17 | |
16 | |
12 | |
11 |
User | Count |
---|---|
38 | |
28 | |
27 | |
20 | |
18 |