Filter Bar Chart by other visual

[joshua1990]

Hi experts!

I have a bar chart that shows me the total sales for the current yeark on a weekly aggregation (x axes).

Then I have a matrix that shows me the top 10 article that have been sold in the previous week. On this visual I have 2 filters:

• Current Week Filter
• Top 10 Article based on Measure [Sales]

Now I would like to click in the matrix to display the sales in the bar chart for the full year. 

When I click in the matrix then I just get the value for the previous week, not the full history. Probably because there is filter (previous week) on the matrix visual.

How can I get the full history?

[Gabriel_Walkman]

The user experience would seem a bit confusing imho. Perhaps have a look at bookmarks to create a button for yearly graphs?

If you definitely want it as you described, maybe use a [total sales] measure something like
var _year = max( 'Calendar'[year] )
return
if( hasonevalue( [article] ),

    calculate( [sales], all( 'Calendar' ), 'Calendar'[year] = _year ),
    [sales]

)