Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a fact table with several fields that indicate a special type of exception. If a record has an exception, then the column value for that exception will be a 1 otherwise it is zero. A record may have an multiple different exceptions. I would like to use the following columns as field parameters to filter a table. It seams to work for the Card Visualization when I add the exception field parameter to it, but it does not filter the table.
How can I get the measure field parameters to filter my table visual? Thanks in advance.
Sample Data (Pre slicer selection)
Invoice # | Create Date | Payment Method | Supplier Name | Total Amount | Is Exception | Is Subtotal Amt Exception | Is Subtotal % Exception | Is Header Amt Exception | Is Header % Exception | Receipt Already Match Exception | No Receipt PO Closed | No Receipt for Invoice |
I123456789 | 8/1/2023 | Accounts Payable | Sysco | 100 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |
I123456790 | 8/2/2023 | Accounts Payable | HD Supply | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
I123456791 | 8/3/2023 | Accounts Payable | Office Depot | 350 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
I123456792 | 8/4/2023 | Accounts Payable | Grainger | 125 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
I123456793 | 8/5/2023 | Accounts Payable | Walmart | 625 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 |
I123456794 | 8/6/2023 | Pcard | 7 Eleven | 715 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 |
I123456795 | 8/7/2023 | FinTech | Souther Glazers | 225 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
Expected Outcome
Each of the fields marked with an "Is" prefix are the field parameters. When I select one of these from the field parameter slicer, I'd like it to filter the table visualization for that column to just show records with a 1 value.
Example: If I click the "Is Header Amount Exception" on the field parameter slicer, the table visualization should only show the following rows.
Invoice # | Create Date | Payment Method | Supplier Name | Total Amount | Is Exception | Is Subtotal Amt Exception | Is Subtotal % Exception | Is Header Amt Exception | Is Header % Exception | Receipt Already Match Exception | No Receipt PO Closed | No Receipt for Invoice |
I123456789 | 8/1/2023 | Accounts Payable | Sysco | 100 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |
I123456793 | 8/5/2023 | Accounts Payable | Walmart | 625 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 |
I123456794 | 8/6/2023 | Pcard | 7 Eleven | 715 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 |
Hi @jbauer22
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Done. I editted the original comment with the sample data and the disired outcome. Thanks!