Conditional filter by chart selection

[AdamDel]

Hi community,

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):

• Trade Lane
• these are the collection/delivery locations for each transit stage. Not important for the issue but helps with the visualisation.
• Item_Number
• the item being delivered.
• Transit
• the transit stage, all items will have 6 eventually
• Performance
• the performance of each transit stage

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:

I hope that makes sense. I have a sample pbix available via WeTransfer (WeTransfer) or alternatively you can use the table below:

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

Thank you

[Anonymous]

Hi @AdamDel ,

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?

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AdamDel]

Hi @Anonymous,

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:

Delayed

• Item_2
• Item_4
• Item_5

On Time

• Item_3
• Item_6
• Item_7
• Item_10

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:

thanks