Removing one filter from another Visual

[Anonymous]

Hi,

I have two visuals on a dashboard.

Visual 1 (Cakechart):

- This is showing the value of todays inventory split up in business area.

- It is filtered on Latest date from the date table

Visual 2 (Linechart):

- This one is showing the daily change using this formula

-----

DailyChange  =

VAR Current =

    CALCULATE(

        Inventory[Value],

        FILTER(

            DimDate, DimDate[Date] = MAX(DimDate[Date])

        )

    )

VAR Prev =

    MAXX(

        FILTER(

            ALL(

                DimDate[Date]

            ),

            DimDate[Date] < MAX(DimDate[Date])

        ),

        DimDate[Date]

    )

VAR PrevInventory =

    CALCULATE(

        Inventory[Value],

        FILTER(

            ALL(

                DimDate

             ),

             DimDate[Date] = PrevDate

        )

    )

RETURN Current - Prev

------

The problem:

When I select one business area on the cakechart my line chart gets filtered on both date and business area, but I only want it to filter on the business area so that the line chart remains.

I have tried different combinations of ALLEXCEPT and REMOVEFILTER, but I cant seem to get the right outcome.

Regards,

Anders

[v-jingzhang · Accepted solution]

Hi @Anonymous 

Create a measure to calcualte the value on the latest date and put it into the pie chart to replace the original column field. And remove the date filter on the pie chart. 

Latest Value = CALCULATE(SUM('FACT'[Value]),FILTER(DIM_Date,DIM_Date[Date]=MAX(DIM_Date[Date])))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[FarhanAhmed]

You may want to change the way of interaction between visuals

Also, make sure that you have valid data for your business Area that is selected.

Power BI - Edit Interactions features - Power BI Docs

Change how visuals interact in a report - Power BI | Microsoft Docs

[Anonymous]

This solution turns off all interaction. I dont want that, I still want it to filter on business area.

[FarhanAhmed]

Can you please share some sample data after removing sensitive information?

[Anonymous]

Hi,

I uploaded some sample data here.

Basically, I would like the line chart to still show daily development even when selecting a store on the cake chart.

Thanks.

A