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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
jaryszek
Impactful Individual
Impactful Individual

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
Impactful Individual
Impactful Individual

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Kudoed Authors