Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jbauer22
Frequent Visitor

Filter Table Based on Field Parameter Slicer of Measures of 1s and 0s

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.

 

jbauer22_0-1692370032745.png

 

How can I get the measure field parameters to filter my table visual?  Thanks in advance.

 

Sample Data (Pre slicer selection)

Invoice #Create DatePayment MethodSupplier NameTotal AmountIs ExceptionIs Subtotal Amt ExceptionIs Subtotal % ExceptionIs Header Amt ExceptionIs Header % ExceptionReceipt Already Match ExceptionNo Receipt PO ClosedNo Receipt for Invoice
I1234567898/1/2023Accounts PayableSysco10011111000
I1234567908/2/2023Accounts PayableHD Supply50000000000
I1234567918/3/2023Accounts PayableOffice Depot35010000100
I1234567928/4/2023Accounts PayableGrainger12500000000
I1234567938/5/2023Accounts PayableWalmart62510011000
I1234567948/6/2023Pcard7 Eleven71511010000
I1234567958/7/2023FinTechSouther Glazers22510000010

 

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 DatePayment MethodSupplier NameTotal AmountIs ExceptionIs Subtotal Amt ExceptionIs Subtotal % ExceptionIs Header Amt ExceptionIs Header % ExceptionReceipt Already Match ExceptionNo Receipt PO ClosedNo Receipt for Invoice
I1234567898/1/2023Accounts PayableSysco10011111000
I1234567938/5/2023Accounts PayableWalmart62510011000
I1234567948/6/2023Pcard7 Eleven71511010000

 

 

2 REPLIES 2
Ritaf1983
Super User
Super User

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!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.