Skip to main content
Microsoft Idea

Power BI

New

Possibility to show items that were filtered out / Possibility Invert Slicer

Vote (4) Share
Michaela Maier's profile image

Michaela Maier on 14 Jul 2023 10:22:49

Hi everyone,


I am currently working on a case where we have a report that shows fuel consumption of ships. There is sometimes faulty data (very low fuel consumption for a long journey, etc.) and my customer likes to filter them. I have created a page with filters that sync to all other pages of the report except for one page where he likes to display these outliers. In this case it would be very useful to be able to invert a slicer and show everything that is not selected on the other pages.

Comments (1)
Michaela Maier's profile image Profile Picture

Michaela Maier on 14 Jul 2023 10:26:14

RE: Possibility to show items that were filtered out / Possibility Invert Slicer

I have found a few examples online with disconnected tables or measures that can calculate the sum of filtered out data, however this is not what I want to achieve here. I want to be able to show a table with dims and metrics just like usual.