Filter Table Visual based on multiple Conditions

[Anonymous]

Hello everyone,

Hope you are doing good.

I need help with filtering on a table visual. 

The sample data would be like this-

Order No.	Condition1	Condition2	Condition3	Customer No.	Amount	Location
123	1	A	X	A1	1000	Houston
234	0	A	Y	A1	1000	Houston
345	1	B	Z	A2	3000	California
456	0	C	Z	A2	2000	California

I need multiple filters which filter the table visual based on multiple conditions.

For eg- 

Filter1 should return the Order No. with Condition1=1 AND Condition2=A AND Condition3=X. 

Filter2 should return the Order No. with Condition1=0 AND Condition2=A AND Condition3=X. 

Filter3 should return the Order No. with Condition3=Z. 

Similarly I need 10 filters that would filter a table visual with order details like-

Order No.	Customer No.	Amount	Location
123	A1	1000	Houston
234	A1	1000	Houston
456	A2	2000	California

When I select Filter1, the table should show only order details for Order No.=123.

When I select Filter2, the table should show no values.

When I select Filter3, the table should show orders with Order No. =345,456

When I select Filter1 and Filter3, the table should show orders with Order No. = 123,345,456

What would be the best approach to solve this? 

Thanks in advance

Akshay

[PijushRoy · Accepted solution]

HI @Anonymous 

Please use the Button and bookmark to create a predefined filter
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks?tabs=powerbi-desktop

Please find the PBIX file