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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
afos111
Frequent Visitor

filtering two unlike values

All, im running product on an assembly with numerous steps from application to inspection etc.

 

On step two there is an inspection for certain items and then later down the road at step seven there is an overall inspection.

 

I am trying to filter out the failures at step seven to see who inspected the item at step two.

 

When i try to filter the failure it  will not show the data for the pass at step two becuase no defect happened in that area.

 

Any suggestions ?

afos111_1-1671064727957.png

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@afos111 , Not very clear, but you can use +0 in your measure or try this option to show blank values

 

Show item with No data new.png

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hello amitchandak, im trying to be as descrite as possible without giving any info out. The said items are serialized and have scans in the system at each step. When clicking on the bottom graph "failures" it is filtering out that failure because the top graph is showing the passes in step two. Im trying to filter the serial number to show who inspected that failed serial number at step two.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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