Apply Slicer as Filter for all but one value in Column

[fourmj]

Hi, does anyone have experience with a situation in which they want to use a slicer on all BUT one value in a column? Basically, I have a column with 10 text values. These text values serve as the rows of a matrix. However, one value is special. It is called "Original Plan". All the other values are deviations of this value. So, in the matrix, I want to keep "Original Plan" as the top row, no matter what. Then the slicer is used to determine which of the other 9 values should be rows under Original Plan.

Here's a picture of the visualization:

And the underlying data:

I would like to remove "Original Plan" from the slicer and have it somewhow pinned to the top of the matrix. It should always be there and the user shouldn't have the option to remove it. Not quite sure how to do that though.

Any ideas? Thank you!

[ddpl · Accepted solution]

Step 1 : Hi firstly create one new table in excel as per below

SituationCatergory

Original value	Scenario A
Original value	Scenario B
Original value	Section C
Original value	Section D
Original value	Section E mode1(Mode1)
Original value	Section E Mode 2
Original value	Section E Mode 3
Original value	BOth A and B
Original value	Both A and C
Scenario A	Scenario A
Scenario B	Scenario B
Section C	Section C
Section D	Section D
Section E mode1(Mode1)	Section E mode1(Mode1)
Section E Mode 2	Section E Mode 2
Section E Mode 3	Section E Mode 3
BOth A and B	BOth A and B
Both A and C	Both A and C

Step 2 : Then creat relationship between tables

Please accept as solution if its worked

[fourmj]

Thank you! This is a very clever solution.