Filter Table depending on value from a Donuts charts

[newphoto]

I have spent an hour finding a solution for my problem,  but not getting there....

I have my report: 

When i choose for example 'Open' from 'Overdue Tickets' Charts, i want to see in table just the value where 'Finish until' date is smaller as today.

When i choose 'Open' from  'Next 7 Days Tickets' Chart, i want to see in the table just value with 'Finish until' date  between tomorrow and tomorrow+7 Days. 

For the charts i created two measures where i use Filter function to select just the values with the desired date.

But i don't know how to filter the table depending on the date from my Charts.

Any ideas?

Thank a lot

[v-sihou-msft · Accepted solution]

@newphoto

In this scenario, when you click in the Donut, only the category you selected will be applied as fitler on other visuals. So your table visual will only be filtered with "OPEN", it can never determine you click it from the "Overdue" or "Next 7 days" charts. The "Next 7 days" filter only works within your measure.

For your requirement, you should add a column to tag if the date in current row is within "Next 7 days".

Date Range =
IF (
    ( Table[Finish Until] - TODAY () )
        <= 0,
    "UP TO TODAY",
    IF (
        ( Table[Finish Until] - TODAY () )
            > 0
            && ( Table[Finish Until] - TODAY () )
                <= 7,
        "NEXT 7 DAYS",
        "OTHER"
    )
)

Then you can populate above colum into a slicer to filter the Donut and Table visual.

Regards,,

[newphoto]

Thanks a lot. Your help is very much appreciated!

[newphoto]

Any ideas please?