Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Interaction between Stacked bar chart

Hello All,   Need your inputs.   I have a report which has 4 stacked bar charts. I want to make interaction like - if select a bar in one chart then it should lock there and act as a filter on an...
Show and Tell
TomMartens's avatar
TomMartens
Super User
8 years ago

Hey,

 

unfortunately this kind of "hierarchical" or "cascading" filtering is not supported, I guess the concept of cross-filtering makes this currently very difficult.

 

For this reason I use a matrix visual, where I can achieve something similar, because it's also possible to use a value as filter.

 

Maybe this gives you an idea.

 

Regards

Tom

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Tom,

 

Thanks for quick response but I didn't understand how to get something closer with matrix visual. Could you please shed some light on this in details?

 

Thanks

Harshad

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

    Hey,

     

    maybe this gives you an idea. The Matrix Visul has Month and Customer nested on rows and items on columns

     

    The first Screenshot shows all the values for the year 2015

     

    The next visual shows all the values of the year 2015 for the item 5, I just selected the column header I5

     

     

    And finally I selected the value 20 for April (Row Header) in the column I5

     

    Of course this is not exactly what you are looking for, but I got used to use the Matrix Visual to combine Filter in a lot of my reports.

     

    Maybe this gives you an idea.

     

    Regards

    Tom

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Tom,

       

      I really appreciate your time and efforts for your help. I will map this with my requirement.

       

      Thank you again!