Reverse filtering

[Victormar]

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 🙂

[Victormar]

I tried that already, but I am unsuccessful at creating the measure. That is what I need help with

[lbendlin]

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...

[Victormar]

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 🙂

[lbendlin · Accepted solution]

There are a couple of fallacies at work here.

- you will never see P

- the last rule seems awkward/redundant.

See attached

[Victormar]

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 😄

[lbendlin]

Use a disconnected table to feed your slicer, and use a measure as your visual filter.