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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.