Custom for a particular visual

[achowsy]

I have data that have dates that span the whole year.

I have 3 visuals. 

2 visuals are based on the latest date.  So I have filters that filter to the latest date and it applied properly.

When it comes to the 3rd visual, I need it to display a graph with an axis that uses all the dates.  I want to be able to click and select certain fields in the other 2 visuals and then use those fields  as a filter for the 3rd visual without "the latest date filter" impact the listing of all dates in the 3rd visual.

Please help me as I read and tried a lot of methods but could not resolve.

[sturlaws]

Hi,

since you have tried a different methods, it might be a good idea to the let forum know what you tried, so we don't investigate possible solutions you have already ruled out.

But have you tried this:
In your date-table, add a column which is 1 when it's equal to your last date, 0 for all others.
Lets say you are looking at sales. Create a measure like this

salesLastDate=calculate(sum(Table[sales]);filter(Dates;Dates[IsLastDate]=1))

and another one like this

sales = SUM('Table'[sales])

Not need to set any filter on the visuals

cheers,
Sturla