Hi @sbott ,
In Power BI, when you want a slicer on one page (like a configuration page) to filter most visuals across your report but not affect certain visuals on a different page, the built-in “Edit Interactions” tool won’t help because it only applies within the same page. To get around this limitation, you can modify the DAX measures used in those specific visuals so they explicitly ignore the slicer filter.
For example, if your slicer filters by the [Region] column and you want a visual to ignore that filter, you can write your measure using REMOVEFILTERS like this:
Sales_Ignore_Region =
CALCULATE(
SUM(Sales[Amount]),
REMOVEFILTERS(Sales[Region])
)
This approach ensures that the measure will calculate the sales amount without applying any filters from the [Region] slicer—even if it’s selected on a different page.
Alternatively, if your slicer uses a disconnected table (which is often done on configuration pages), you can avoid using that slicer altogether by not incorporating any logic that references it in your measure. If the slicer is based on a custom disconnected table called 'DisconnectedRegion', and most visuals use something like this:
Sales_With_Region_Filter =
CALCULATE(
SUM(Sales[Amount]),
FILTER(
Sales,
Sales[Region] = SELECTEDVALUE('DisconnectedRegion'[Region])
)
)
Then for the visuals you want unaffected, just use a basic measure that doesn’t refer to 'DisconnectedRegion':
Sales_Ignore_Config_Slicer =
SUM(Sales[Amount])
This way, that particular visual will not respond to the slicer on the configuration page.
Best regards,
