cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Apply Slicer as Filter for all but one value in Column

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!

1 ACCEPTED SOLUTION
Solution Sage

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

2 REPLIES 2
Solution Sage

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

Frequent Visitor

Thank you! This is a very clever solution.

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.