Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
I have 3 Issues.ISSUE_KEY records, as shown below. Of these 3 records, only 1 (SUP-4000) also exists in IssueLinks.
When I add IssueLinks.ISSUE_KEY, only the record that exists in both Issues and IssueLinks appears:
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!
Solved! Go to Solution.
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.
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?
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
62 | |
59 | |
56 |