Visualization Interaction - Keeping different Date filters

[AV155]

Hello,

I have a Table visualization that shows customers and revenue with filter of "In Current Year".  On the same page, I have a Bar Chart visualization showing revenue over the past 12 months.   What I would like is when a user clicks on an individual customer in the Table, the bar chart keeps the "past 12 months" filter while showing data only for that customer.  Currently, the bar chart also assumes the "In Current Year" filter when a customer is selected, which I do not want to happen.

Is this possible to achieve?

[amitchandak · Accepted solution]

@AV155 , If current is because of filter or slicer, it will pass the value. Try to create a measure for the current year then it should only pass customer

example

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))

[AV155]

That makes sense.  I should have thought about making measures to accomplish this.  Thanks!!