Forum Discussion

jaryszek's avatar
jaryszek
Super User
1 year ago
Solved

Not matching keys relationships

Hello,

I have relationship like here:


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:

 


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




 

Need Help
  • mdaatifraza5556's avatar
    mdaatifraza5556
    1 year ago

    Hi jaryszek 

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

     

     

     


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

3 Replies

  • mdaatifraza5556's avatar
    mdaatifraza5556
    Super User
    1 year ago

    Hi jaryszek 

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

     

     

     


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

    • jaryszek's avatar
      jaryszek
      Super User
      1 year ago

      I have put this :

       

      But still blank is there...

      Best,
      Jacek