Forum Discussion

prabhatnath's avatar
prabhatnath
Icon for Advocate III rankAdvocate III
3 years ago
Solved

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

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 NamePriceIsVendor
CPU7000NO
RAM3200NO
HDD2000NO
SSD4000NO
FAN500YES
CABINET1200YES
PSU800YES
GPU5000NO
COOLING200YES


Thanks,
Prabhat