Show all dates in a chart when another chart is selected that only contained one date

[bjw210]

I need to keep a chart in tact for all periods while filtering the data on the client selected in another chart. 

Thought this was the right route but can't get this to work:

Disregard Date filter when client is selected = 
CALCULATE(
    SUM(Sheet1[Amount]),
    ALLEXCEPT(Sheet1,Sheet1[Client],Sheet1[Bucket],Sheet1[Date])
)

Example Data (also attached):

Region	Client	Date	Bucket	Amount
East	Tom	10/15/2021	61-90	3
East	Tom	10/15/2021	61-90	2
West	Jane	10/15/2021	61-90	1
West	Jane	10/15/2021	61-90	3
East	Tom	10/15/2021	91-180	1
East	Tom	10/15/2021	91-180	3
West	Jane	10/15/2021	91-180	3
West	Jane	10/15/2021	91-180	3
East	Tom	10/15/2021	181-360	3
East	Tom	10/15/2021	181-360	2
West	Jane	10/15/2021	181-360	2
West	Jane	10/15/2021	181-360	3
East	Tom	10/15/2021	361+	2
East	Tom	10/15/2021	361+	3
West	Jane	10/15/2021	361+	1
West	Jane	10/15/2021	361+	1
East	Tom	10/8/2021	61-90	2
East	Tom	10/8/2021	61-90	1
West	Jane	10/8/2021	61-90	2
West	Jane	10/8/2021	61-90	2
East	Tom	10/8/2021	91-180	1
East	Tom	10/8/2021	91-180	2
West	Jane	10/8/2021	91-180	2
West	Jane	10/8/2021	91-180	3
East	Tom	10/8/2021	181-360	3
East	Tom	10/8/2021	181-360	1
West	Jane	10/8/2021	181-360	1
West	Jane	10/8/2021	181-360	2
East	Tom	10/8/2021	361+	3
East	Tom	10/8/2021	361+	2
West	Jane	10/8/2021	361+	3
West	Jane	10/8/2021	361+	2
East	Tom	10/1/2021	61-90	3
East	Tom	10/1/2021	61-90	1
West	Jane	10/1/2021	61-90	3
West	Jane	10/1/2021	61-90	2
East	Tom	10/1/2021	91-180	2
East	Tom	10/1/2021	91-180	1
West	Jane	10/1/2021	91-180	2
West	Jane	10/1/2021	91-180	2
East	Tom	10/1/2021	181-360	2
East	Tom	10/1/2021	181-360	2
West	Jane	10/1/2021	181-360	1
West	Jane	10/1/2021	181-360	1
East	Tom	10/1/2021	361+	2
East	Tom	10/1/2021	361+	1
West	Jane	10/1/2021	361+	1
West	Jane	10/1/2021	361+	1
East	Tom	9/24/2021	61-90	1
East	Tom	9/24/2021	61-90	3
West	Jane	9/24/2021	61-90	3
West	Jane	9/24/2021	61-90	3
East	Tom	9/24/2021	91-180	2
East	Tom	9/24/2021	91-180	3
West	Jane	9/24/2021	91-180	1
West	Jane	9/24/2021	91-180	2
East	Tom	9/24/2021	181-360	3
East	Tom	9/24/2021	181-360	3
West	Jane	9/24/2021	181-360	1
West	Jane	9/24/2021	181-360	2
East	Tom	9/24/2021	361+	3
East	Tom	9/24/2021	361+	3
West	Jane	9/24/2021	361+	1
West	Jane	9/24/2021	361+	1
East	Tom	9/17/2021	61-90	2
East	Tom	9/17/2021	61-90	3
West	Jane	9/17/2021	61-90	3
West	Jane	9/17/2021	61-90	3
East	Tom	9/17/2021	91-180	3
East	Tom	9/17/2021	91-180	2
West	Jane	9/17/2021	91-180	1
West	Jane	9/17/2021	91-180	2
East	Tom	9/17/2021	181-360	3
East	Tom	9/17/2021	181-360	2
West	Jane	9/17/2021	181-360	2
West	Jane	9/17/2021	181-360	2
East	Tom	9/17/2021	361+	2
East	Tom	9/17/2021	361+	3
West	Jane	9/17/2021	361+	2
West	Jane	9/17/2021	361+	3

[v-henryk-mstf · Accepted solution]

Hi @bjw210 ,

According to your description, I did the test. It is a problem caused by the hierarchy of the date field. The reference is as follows:

Alternatively, you can use the Edit interactions function to filter the specified visuals.

If the problem is still not resolved, please point it out. Looking forward to your reply.

Best Regards,
Henry

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

[lbendlin]

Have you considered disabling interactions for that visual?  That'll give you the required filter exceptions without a need to code them manually.

[bjw210]

I did consider that, but i need the Tom or Jane selection to pass to the visuals while not passing the dates.