Filter Report Data based on User Selection for YES - NO Value Based data

[prabhatnath]

Hi Experts,

I have the below table loaded into Power BI and currently the report shows all visuals based on all rows in the Datasource.
I want to exclude the Vendor records from the report visuals so for now I have applied a Page level filter IsVendor = NO and it is all good.

Instead, I want to have a selection (Something like "Include Vendor Records") that is by default unselected and users can select if they want to include vendor data as well. Without Selection, the Report should show records where Isvendor = NO.

Having a Slicer visual on isVendor Field and shown as checkboxes will show YES and NO options and will work, but I think this will confuse users, so looking for having just one selection for Include Vendor Records.

Item Name	Price	IsVendor
CPU	7000	NO
RAM	3200	NO
HDD	2000	NO
SSD	4000	NO
FAN	500	YES
CABINET	1200	YES
PSU	800	YES
GPU	5000	NO
COOLING	200	YES

Thanks,
Prabhat

[v-shex-msft · Accepted solution]

Hi @prabhatnath,

You can try to use ISFILTERED function with if statement to package the original expression and use its status to redirect to different filter expressions.

ISFILTERED function (DAX) - DAX | Microsoft Learn

Regards,

Xiaoxin Sheng