Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |