Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Clustered Bar Chart - Selection

I have a Clustered Bar Charts in a dashboard with one-many relations. Selecting a bar highlights the relevant bars (data) on the other. My client want to only display the highlighted bar and totally ...
  • Thejeswar's avatar
    7 years ago

    Hi Anonymous,

    Do you mean filtering out the second chart based on selections in the first chart? Is so, below solution helps

     

    "Use Edit Interactions option from Format tab that appears when you click on a visual. In the Edit Interactions change the property for the second visual to FIlter"

     

    This will filter out the second graph while you make selections in the first graph. But as you click on the other graph, the other data bars starts appearing. 

     

    Get Detailed information about Edit Interactions here

     

    On the other hand, if you mean that when you select on a visual, then the second visual should get filtered and that the other data should not return back on clicking on the graph, then that's not directly available. But you can achieve it indirectly (which might require the user's contribution as well)

     

    Set the First Graph to Filter out the second graph in Edit Interactions

    When you click the first graph data bar, your second graph will get filtered based on the "Edit Interactions". Now right-click on all the bars in the second graph that you need and click "Include". Now your graph will be fully filtered and that only those bars which you included will stay. Know more about this here

     

    For your reference, find the screenshot below