Forum Discussion
Simple bidirectional filtering between bar chart and matrix not working!
- 1 year ago
Ok see if this works for you. Duplicate the single table and set up th emodel as follows.
Duplicate this table
Now create two measure to act as filters for each corresponding table:
Filter Person T1 = COUNTROWS ( CALCULATETABLE ( VALUES ( 'Dim ID'[dID] ), FILTER ( 'Table 2', SUM ( 'Table 2'[Wert] ) <> 0 ) ) )Filter Person T2 = COUNTROWS ( CALCULATETABLE ( VALUES ( 'Dim ID'[dID] ), FILTER ( 'Table 1', SUM ( 'Table 1'[Wert] ) <> 0 ) ) )Add the ID column from the ID dimenion table and set up each filter with its corresponding measure in the filter pane
and this is the final result
- 1 year ago
Sure, you can download it from here:
UvonW Ensure that the relationships between your tables are correctly set up. You should have a relationship between the "initial table" and "1Attribut" as well as between the "initial table" and "2Attribut" using the ID column. The relationships should be set to "Both" for cross-filter direction.
Verify that the interactions between the visuals are correctly set. You mentioned that you have already checked this, but it’s worth double-checking.