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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
olimilo
Continued Contributor
Continued Contributor

Data from related table not showing in table visual

I have 2 tables related 1:M:

olimilo_1-1717597573025.png

 

When plotted on a table visual, only the (first 3) columns from the M side of the relationship are appearing in the table visual. In this test case, I am sure all there are matches from the 1 side of the relationship so the data not displaying does not seem right:

 

olimilo_0-1717597440694.png

Is there any way I can fix this?

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

Can you validate matches?, add a calculated column in Supplier_BaseData, validate = Related(SupplierList[WebTrfld], and verify that all rows match. That is, in the calculated column you should not have blank values.

View solution in original post

3 REPLIES 3
Missionman
New Member

Hi everyone,

 

I’ve recently completed my data analytics training and am eager to put my skills into practice through real-world projects. I’m looking for a mentor who can:

Assign realistic projects to help me apply my training.

Provide timelines to keep me accountable.

Share feedback to guide my improvement and growth.

 

I understand that your time is valuable, and I will ensure the process is as smooth as possible. Even small guidance—like suggesting a dataset or reviewing my work briefly—would mean a lot to me.

 

If you’re an experienced data analyst who’s passionate about mentoring or know someone who might be interested, I’d be incredibly grateful for your support.

 

  • Thank you for helping me take the next step in my data analytics journey!
Anonymous
Not applicable

Hi @olimilo ,

 

Whether the advice given by @Syndicate_Admin   has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

 

Best Regards,

Neeko Tang

Syndicate_Admin
Administrator
Administrator

Can you validate matches?, add a calculated column in Supplier_BaseData, validate = Related(SupplierList[WebTrfld], and verify that all rows match. That is, in the calculated column you should not have blank values.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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