Visual interaction remove filter on row

[ThomasEpp]

Searched for it but solutions with remove filter didn't work for me as I would need to remove the filter from the row. I tried all, allexcept, removefilter but always the date was filtered as it's in the row. 

I have two visuals. One visual shows the stock of today. It's filtered by a separate column that checks if the stockdata is the latest with true/false. So this visual is filtered to true to only show the latest day

Then I have a second visual that shows the stock evolution. Now I would like to press on one of the article in Visual 1 and then have in Visual 2 filtered the stock evolution based on the product. But whatever I do, Visual 2 is filtered to only the latest date.

I want to press on the visual Article A for example and then have on the right side all the dates. But right now it always filters to only the latest date

Somehow feels like an easy problem. But didn't manage to get it done 😞

If someone needs the example pbix file I uploaded it here:

https://drive.google.com/file/d/1C-IgSyVZtXVv07TcgsQPHwmXzJgLnKie/view?usp=sharing

[pmreis · Accepted solution]

Hi @ThomasEpp ,

I've removed your filter from filter pane "Last day = True"
And created a new measure 

Stock Today = CALCULATE(sum('Table'[Stock Quantity]),LASTDATE('Table'[Date column]))

This allows you to see the current stock, but without the need of filtering your first table. The calculate function does the context change for you.

Here is the adjusted file: https://github.com/pedroreis81/PBI_Problem_Solving/blob/main/Example%20Solved%20-%20Calculate%20Stoc...

Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple

If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

Find me at LinkedIn

[ThomasEpp]

Wohooo. worked. Smart! Thanks a lot!!!