Remove interaction between two visual elements

[Fern_21]

Hi all!

I am using DirectQuery mode and have a revision filter coming from the items table.

On a line chart, the X-axis has the same revision field from items, while the Y-axis has other columns coming from items.

My goal is: when I filter by a revision, the line chart should not be filtered. If I filter for R6, the line chart should still show all revisions.

I tried using edit interactions to block the filter, but it doesn't work. How can I achieve this?

Thanks

[pankajnamekar25 · Accepted solution]

Hello @Fern_21 

try with measure

Total Sales Ignore Slicer =

CALCULATE(

    SUM(Items[Sales]),

    REMOVEFILTERS(Items[Revision])

)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated

[v-veshwara-msft]

Hi @Fern_21 ,

We’re following up once more regarding your query. If it has been resolved, please mark the helpful reply as the Accepted Solution to assist others facing similar challenges.

If you still need assistance, please let us know.
Thank you.

[v-veshwara-msft]

Hi @Fern_21 ,

Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries. 

Otherwise, feel free to reach out for further assistance.

Thank you.

[v-veshwara-msft · Accepted solution]

Hi @Fern_21  ,

Thanks for using Microsoft Fabric Community,

Just checking in to see if your issue has been resolved.

As mentioned earlier by @pankajnamekar25  , using REMOVEFILTERS(Items[Revision]) in your measure is a valid way to prevent the slicer from affecting the line chart:

Total Sales Ignore Slicer =
CALCULATE(
SUM(Items[Sales]),
REMOVEFILTERS(Items[Revision])
)

Alternatively, if you want complete separation between the slicer and the chart (including the X-axis), you can create a disconnected revision table:

Revisions = DISTINCT(Items[Revision])

Then use this measure:

Total Sales Ignore Slicer =
CALCULATE(
    SUM(Items[Sales]),
    FILTER(
        ALL(Items),
        Items[Revision] = SELECTEDVALUE(Revisions[Revision])
    )
)

Use Revisions[Revision] on the X-axis of your line chart. This ensures the slicer will not influence the chart at all.

Let us know if this helps or if you're still facing any issues.

Please consider marking the helpful reply as Accepted Solution to assist others with similar issues.

Thank you.

[pankajnamekar25 · Accepted solution]

Hello @Fern_21 

try with measure

Total Sales Ignore Slicer =

CALCULATE(

    SUM(Items[Sales]),

    REMOVEFILTERS(Items[Revision])

)

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated