Hello, I am having an issue with the rendering for two stacked bar charts (A&B) with several bars each. Basically, for these charts, my dataset consists of many rows and two columns, with each column having several different categories (each represented by a bar in a chart). Each row value fits within only one of the categories for each column.
If you click on bars within one chart, it acts as an "OR" function (e.g. if you click on bars within Chart A, the dashboard filters all row values that are within one of categories represented by the bars). Clicking bars between the two charts acts as an "AND" function between the charts.
So if I click on several bars in Chart A and several bars in Chart B, the dashboard will show all row values that are both within one of the selected bars of Chart A AND within one of the selected bars of Chart B.
However, if I then, for example, isolate only one bar in Chart B (call it bar 5), visually, certain remnants of bars from Chart A that have no row values that are within the bar 5 category of Chart B still remain (see attached pic). If I reset Chart A it corrects this behavior and only categories from Chart A that are also within the category selected from Chart B will show.
Anyone encounter something similar and know how to correct it?