Forum Discussion
Reverse filtering
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 🙂
There are a couple of fallacies at work here.
- you will never see P
- the last rule seems awkward/redundant.
See attached
6 Replies
Use a disconnected table to feed your slicer, and use a measure as your visual filter.
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-Forum/ba-p/963216
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/1447523Hello,
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 🙂
