Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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!
Solved! Go to 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
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
Thank you! This is a very clever solution.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |