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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
jaryszek
Power Participant
Power Participant

Not matching keys relationships

Hello,

I have relationship like here:

jaryszek_0-1747134062949.png
and in Dim_Date i have only December 2024 and in CostCenterresourcesCosts I have 2023 , 2024 and 2025 months.

What I am expecting that it will show only December 2024 on Slicer:

jaryszek_1-1747134149094.png

jaryszek_0-1747134217240.png

 


but this is showing also Blanks. 
How to be sure that power bi will show only matching rows...

How to enforce it to not show blanks? Can i enforce it from relationships or from visual level or i need to make relationships in DAX?

Best,
Jacek




 

1 ACCEPTED SOLUTION
mdaatifraza5556
Super User
Super User

Hi @jaryszek 

Select your slicer --------->>>> Go to  filter pane and there, Uncheck the blank 

 

Screenshot 2025-05-13 165911.png

 

 


If this answers your questions, kindly accept it as a solution and give kudos.

View solution in original post

3 REPLIES 3
jaryszek
Power Participant
Power Participant

Ok thanks managed to do this!

mdaatifraza5556
Super User
Super User

Hi @jaryszek 

Select your slicer --------->>>> Go to  filter pane and there, Uncheck the blank 

 

Screenshot 2025-05-13 165911.png

 

 


If this answers your questions, kindly accept it as a solution and give kudos.

I have put this :

jaryszek_0-1747142197848.png

 

But still blank is there...

Best,
Jacek


Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.