Forum Discussion

UvonW's avatar
UvonW
Regular Visitor
1 year ago
Solved

Simple bidirectional filtering between bar chart and matrix not working!

Hello, for me it assumes like a very simple problem, but I do not know, why it is not working. I want to create a bar chart and a matrix that can be filtered interactively in both directions. I...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    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

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
1 year ago

UvonW 

 

Is there a particular reason why you are  setting up the model like that?

The convention would be to have a single fact table with dimension table for ID and Attribut

 

Like this:

You can then set up your graphs eith as one or in two separate clustered column charts and just filter the attributs in each

 

Here is the link to your file with the alternative model setup:

https://1drv.ms/u/s!AhGKDZz6e4HehLh5YX_pYCRVmymY3A?e=O6cXlj 

  • UvonW's avatar
    UvonW
    Regular Visitor
    1 year ago

    Thank you for your answer and also the example. Unfortunately this is not what I want to achieve. Since I want to have a filtering between the bar charts as well. 
    Assume Attribut1 is "Food" and Attribut2 are "Drinks" and the ID are personas.


    I also want to have the opportunity to filter "How many personas that like Tomato also drink Juice"

     

    In this case 0. And i want to achieve that by interactively clicking on the barchart. Including the table with the ID (A, B, C), i also want to see "Which persona drinks Juice?" bei clicking on Juice in the barchart.

    • PaulDBrown's avatar
      PaulDBrown
      Icon for Community Champion rankCommunity Champion
      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

      • UvonW's avatar
        UvonW
        Regular Visitor
        1 year ago

        This looks like exactly wha i need. Unfortunately I cam not able to rebuild your example. Could you share your .pbix example? That would be great.