Forum Discussion
Cross-Filtering between bar chart and table using measures in bar chart
I needed to have the legend on my chart that does not change based on report filtering so I created measures to calculate the count of ID’s for each Status. This allowed the legend to stay static no matter what filters are applied to the report page. The problem I now have is that when I select one of the counts in the bar chart (i.e. Actions Complete for DB1), it no longer filters the table with the same data. So the measures I created are not allowing any cross-filtering to the table. One of the measures I created was:
Count of Id for Actions complete =
CALCULATE(COUNTA('Case'[Id]), 'Case'[Status] IN { "Actions complete" })
And I have 7 other measures with different status’s.
The Bar chart has Type for the Axis (which is DB1 and DB2), and each of the measures for values.
The Table shows Type, Status, and a bunch of other values.
Is there a better way to make sure the legend doesn’t change based on filtering or is there a better measure I can write that allows cross-filtering to the table?
Not sure why you would want to confuse your users this way but here's an implementation
6 Replies
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.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 What 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?