Conditional filter by chart selection

Question

Hi community,&nbsp;I have an issue with how I would like to visualise my data and it is quite hard to explain. Unfortunately, I am not able to adjust the structure of the data, such as pivoting, due to the number of rows/columns in the real dashboard.The report is for tracking delivery performance over six separate transit stages at an item level. I have four columns in the example (real data is much larger):&nbsp;Trade Lanethese are the collection/delivery locations for each transit stage. Not important for the issue but helps with the visualisation.Item_Numberthe item being delivered.Transitthe transit stage, all items will have 6 eventuallyPerformancethe performance of each transit stage&nbsp;I then have six bar charts for each transit stage. The problem I have is that I would like to be able click on a chart segment and filter the other charts to show the items in that segment. For example, clicking on the 3 delayed items in transit 6 would filter the other charts to only show those 3 items, allowing us to see their performance in the previous stages:&nbsp;&nbsp;I hope that makes sense. I have a sample pbix available via WeTransfer (WeTransfer)&nbsp;or alternatively you can use the table below:&nbsp;Trade LaneItem_NumberTransitPerformanceTL1_A-BItem_1Transit_1On TimeTL2_A-BItem_1Transit_2On TimeTL3_G-HItem_1Transit_3On TimeTL1_C-DItem_10Transit_1EarlyTL2_E-FItem_10Transit_2On TimeTL3_I-JItem_10Transit_3On TimeTL4_K-LItem_10Transit_4DelayedTL5_O-PItem_10Transit_5DelayedTL6_S-TItem_10Transit_6On TimeTL1_A-BItem_2Transit_1On TimeTL2_A-BItem_2Transit_2On TimeTL3_G-HItem_2Transit_3On TimeTL4_K-LItem_2Transit_4On TimeTL5_M-NItem_2Transit_5On TimeTL6_Q-RItem_2Transit_6DelayedTL5_M-NItem_3Transit_5On TimeTL6_Q-RItem_3Transit_6On TimeTL1_A-BItem_4Transit_1On TimeTL2_C-DItem_4Transit_2EarlyTL3_G-HItem_4Transit_3EarlyTL4_K-LItem_4Transit_4DelayedTL5_M-NItem_4Transit_5On TimeTL6_Q-RItem_4Transit_6DelayedTL1_A-BItem_5Transit_1On TimeTL2_C-DItem_5Transit_2EarlyTL3_G-HItem_5Transit_3On TimeTL4_K-LItem_5Transit_4On TimeTL5_O-PItem_5Transit_5On TimeTL6_Q-RItem_5Transit_6DelayedTL1_C-DItem_6Transit_1On TimeTL2_E-FItem_6Transit_2EarlyTL3_I-JItem_6Transit_3On TimeTL4_K-LItem_6Transit_4On TimeTL5_O-PItem_6Transit_5On TimeTL6_S-TItem_6Transit_6On TimeTL1_C-DItem_7Transit_1EarlyTL2_E-FItem_7Transit_2On TimeTL3_I-JItem_7Transit_3On TimeTL4_K-LItem_7Transit_4On TimeTL5_O-PItem_7Transit_5On TimeTL6_S-TItem_7Transit_6On TimeTL1_C-DItem_8Transit_1On TimeTL2_E-FItem_8Transit_2EarlyTL3_I-JItem_8Transit_3On TimeTL1_C-DItem_9Transit_1On TimeTL2_E-FItem_9Transit_2EarlyTL3_I-JItem_9Transit_3On Time&nbsp;Thank you

anonymous · Answer

Hi&nbsp;AdamDel&nbsp;,
&nbsp;
Is it possible to explain in detail: clicking on the 3 delayed items in transit 6 would filter the other charts to only show those 3 items, allowing us to see their performance in the previous stages?

&nbsp;
Best Regards,Adamk Kong
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;

adamdel · Answer

Hi&nbsp;Anonymous,&nbsp;of course, and thank you for taking time to look at this. So far 7 items have completed transit stage 6 with 3 of them being delayed and 4 delivered on time:&nbsp;DelayedItem_2Item_4Item_5On TimeItem_3Item_6Item_7Item_10&nbsp;What we would like to see when selecting the 3 delayed, is to filter the other charts to only include those 3 items. The same kind of result as if I had used a page filter to manually select those items:&nbsp;&nbsp;thanks&nbsp;

Forum Discussion

Conditional filter by chart selection

2 Replies

Related content

Conditional Filtering Based on Slicer Selection

Conditional Filtering

Grouped summaries with conditional filtering

Filter with conditions

Dynamic Filtering based on date selection

Trade Lane	Item_Number	Transit	Performance
TL1_A-B	Item_1	Transit_1	On Time
TL2_A-B	Item_1	Transit_2	On Time
TL3_G-H	Item_1	Transit_3	On Time
TL1_C-D	Item_10	Transit_1	Early
TL2_E-F	Item_10	Transit_2	On Time
TL3_I-J	Item_10	Transit_3	On Time
TL4_K-L	Item_10	Transit_4	Delayed
TL5_O-P	Item_10	Transit_5	Delayed
TL6_S-T	Item_10	Transit_6	On Time
TL1_A-B	Item_2	Transit_1	On Time
TL2_A-B	Item_2	Transit_2	On Time
TL3_G-H	Item_2	Transit_3	On Time
TL4_K-L	Item_2	Transit_4	On Time
TL5_M-N	Item_2	Transit_5	On Time
TL6_Q-R	Item_2	Transit_6	Delayed
TL5_M-N	Item_3	Transit_5	On Time
TL6_Q-R	Item_3	Transit_6	On Time
TL1_A-B	Item_4	Transit_1	On Time
TL2_C-D	Item_4	Transit_2	Early
TL3_G-H	Item_4	Transit_3	Early
TL4_K-L	Item_4	Transit_4	Delayed
TL5_M-N	Item_4	Transit_5	On Time
TL6_Q-R	Item_4	Transit_6	Delayed
TL1_A-B	Item_5	Transit_1	On Time
TL2_C-D	Item_5	Transit_2	Early
TL3_G-H	Item_5	Transit_3	On Time
TL4_K-L	Item_5	Transit_4	On Time
TL5_O-P	Item_5	Transit_5	On Time
TL6_Q-R	Item_5	Transit_6	Delayed
TL1_C-D	Item_6	Transit_1	On Time
TL2_E-F	Item_6	Transit_2	Early
TL3_I-J	Item_6	Transit_3	On Time
TL4_K-L	Item_6	Transit_4	On Time
TL5_O-P	Item_6	Transit_5	On Time
TL6_S-T	Item_6	Transit_6	On Time
TL1_C-D	Item_7	Transit_1	Early
TL2_E-F	Item_7	Transit_2	On Time
TL3_I-J	Item_7	Transit_3	On Time
TL4_K-L	Item_7	Transit_4	On Time
TL5_O-P	Item_7	Transit_5	On Time
TL6_S-T	Item_7	Transit_6	On Time
TL1_C-D	Item_8	Transit_1	On Time
TL2_E-F	Item_8	Transit_2	Early
TL3_I-J	Item_8	Transit_3	On Time
TL1_C-D	Item_9	Transit_1	On Time
TL2_E-F	Item_9	Transit_2	Early
TL3_I-J	Item_9	Transit_3	On Time