Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello community, hope you are all doing well.
I am struggling with creating a reversed filter for my report. I have tried to follow old posts from the community, but I cannot make it work.
I have a table where I have, among other columns, Part Number and Project State column, that can be either A, B, C or P.
My end goal is to be able to filter this table based on that phases, but that it filters according to this logic:
- If I select P, only A, B, C parts are shown.
- If I select C, only A and B.
- If I select A or B, only A parts are shown.
It doesn't seem complicated, but I cannot achieve it.
Thanks in advance for any help 🙂
Solved! Go to Solution.
There are a couple of fallacies at work here.
- you will never see P
- the last rule seems awkward/redundant.
See attached
I tried that already, but I am unsuccessful at creating the measure. That is what I need help with
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Hello,
Attached a table I created with sample data. I added more columns that I mentioned to the source table, but it is as it looks.
My idea is to create a slicer using the project state column to reverse filter the data, based on the conditions stated:
Project | Level | Part Name | Part Number | State | Project State |
1 | Level 1 | asadad | 1234 | A - In Work | A |
1 | Level 1 | sfgsf | 1245 | B - In Work | B |
2 | Level 1 | fgsad | 1265 | A - In Work | A |
3 | Level 2 | asdasd | 1244 | C - In Work | C |
2 | Level 3 | sdgsg | 12333 | A - Released | A |
3 | Level 2 | asfdsf | 17888 | P - Released | P |
4 | Level 2 | asasf | 19877 | P - In Work | P |
1 | Level 4 | ert | 13435 | C - Released | C |
1 | Level 4 | vvbbn | 12334 | A - In Work | A |
Just to be clear, a slicer based on the Project State Column, result:
- If I select P, only A, B and C are shown in the table.
- If I select C, only A and B.
- If I select A or B, only A.
Hope it makes sense, thanks in advance for you time 🙂
Looks really good! I have applied to my Pbi and works really good. I agree with your comments, it's just what stakeholders want to see.
Thanks again 😄
Use a disconnected table to feed your slicer, and use a measure as your visual filter.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
38 | |
28 | |
26 |
User | Count |
---|---|
99 | |
88 | |
62 | |
42 | |
39 |