Forum Discussion
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 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
- Anonymous3 years ago
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
1 Reply
- AnonymousNot applicable
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