Forum Discussion
Cross-Filtering between bar chart and table using measures in bar chart
Not sure why you would want to confuse your users this way but here's an implementation
Sorry for the late reply. Here is a sample of the data. This sample is also what would be shown in the Table Graph. The picture of the bar chart is included. If I use measures for each status in the bar chart, It no longer filters the table chart. For instance, if I select "Completed" in the bar chart, the table graph still shows all status's (does not filter just the ones that are "Completed"). I need the legend to stay static so on the main page filters, if someone selects location = MB, the legend in the bar chart stays the same.
| Type | Status | Case | Created Date | Location | ID |
| Round | New | 134493 | 7/25/2019 18:22 | MB | 12aTgQAI |
| Round | Complete | 134494 | 7/25/2019 18:22 | MB | 12aTRQAY |
| Round | Complete | 142618 | 8/16/2019 0:36 | B | 1fuIqQAI |
| Round | Under Investigation | 167650 | 10/10/2019 5:17 | A | 3VhnbQAC |
| Round | Complete | 170935 | 10/17/2019 8:17 | A | 3jWqEQAU |
| Round | New | 172259 | 10/20/2019 21:12 | MB | 3lr9uQAA |
| Round | Actions complete | 291820 | 5/12/2020 4:45 | SA | 9UxwKQAS |
| Round | Awaiting closure | 295885 | 5/19/2020 2:37 | SA | 9jMTwQAM |
| Checklist | Complete | 409993 | 11/21/2020 4:39 | C | Dpj1gQAB |
| Checklist | New | 446899 | 1/15/2021 10:25 | W | F1gu9QAB |
| Checklist | Complete | 451779 | 1/23/2021 18:04 | S1 | F47vvQAB |
| Checklist | Complete | 451780 | 1/23/2021 18:04 | S1 | F47w4QAB |
| Checklist | New | 516331 | 5/8/2021 9:13 | W | Hcbg5QAB |
| Checklist | Complete | 528455 | 5/29/2021 22:55 | S2 | 9ECdrQAG |
| Checklist | Awaiting closure | 671056 | 12/3/2021 14:54 | G | MnkbkQAB |
| Checklist | Under Investigation | 671376 | 12/4/2021 6:03 | G | MnspKQAR |
Super UserWhat is your expected outcome? Here is an example that doesn't use measures at all
How is this insufficient for what you are trying to achieve? How do you expect users to interact with the visual?
If you have a slicer on the page for Location and you select G, I want the legend to still show everything. Creating measures allows this to happen but when I then add a table of the data to the page and when I select one of the bars (completed), the table is not filtering to just show completed. That is the consequence I found with the measures. It fixes one problem (keeping legend intact) but does not solve the cross filtering function between the table and the bar chart. Maybe the measures need to be written differently or maybe there is no fix that will keep legend intact and allow the cross-filtering.
- lbendlin
Not sure why you would want to confuse your users this way but here's an implementation