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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
dkpcr5
Helper II
Helper II

Super simple question about table relationships and rows disappearing

Hi there. Feeling like a total newbie asking this, but here goes.

I have two tables, IssueLinks and Issues, with a many-to-one relationship; Issues filters IssueLinks.

relationshiptable.PNG

 

I have 3 Issues.ISSUE_KEY records, as shown below. Of these 3 records, only 1 (SUP-4000) also exists in IssueLinks.

issuestable.PNG

 

When I add IssueLinks.ISSUE_KEY, only the record that exists in both Issues and IssueLinks appears:

bothtables.PNG

 

What I need to have happen instead is that, when I add IssueLinks.ISSUE_KEY to the same table visual, I want 1) all 3 rows from Issues.ISSUE_KEY to still appear, 2) show records in the IssueLinks.ISSUE_KEY column for matching records, and 3) for non-matching rows from IssueLinks, just show blanks.

 

This is the behavior I'd normally expect given the table relationship: Issues filters IssueLinks, not the other way around.

 

I'm sure I'm missing something obvious. Please help!

1 ACCEPTED SOLUTION
littlemojopuppy
Community Champion
Community Champion

Hi @dkpcr5 there's an option in the value wells (where you drop in fields/measures) to show all data.  Right click on the field and check that option.

View solution in original post

3 REPLIES 3
VC_2024
New Member

Hi @dkpcr5 for posting this query. I have the same issue. And for the particular column which was not showing the values is resolved based on the above solution. 

 

And @littlemojopuppy thanks for providing the solution.

But

I have another challenge in the same data that when there are blank rows come then many other fields are not showing the data. As soon as I remove that field from the table then all other columns are showing correctly. How can I resolve this?

littlemojopuppy
Community Champion
Community Champion

Hi @dkpcr5 there's an option in the value wells (where you drop in fields/measures) to show all data.  Right click on the field and check that option.

Fabulous - that did it! Thank you so much!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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