Forum Discussion

ThomasEpp's avatar
ThomasEpp
New Member
2 years ago
Solved

Visual interaction remove filter on row

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

 

 

Need Help
  • pmreis's avatar
    pmreis
    2 years ago

    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%20Stock%20Today.pbix






    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

2 Replies

  • pmreis's avatar
    pmreis
    Most Valuable Professional
    2 years ago

    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%20Stock%20Today.pbix






    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