Table Visual hides values after first column null (columns from different table models)

Hi jmarciogsousa ,

Thanks for reaching out to Microsoft Fabric Community Forum.

Thanks for sharing the screenshots and describing the issue clearly, It’s likely due to how relationships and filter propagation work between your tables in the Power BI data model.

• When creating a table visual with columns from multiple tables in Power BI:
• If you begin with a column from the main table containing actual data, the visual renders correctly.
• However, if you start with a column from a related table that lacks matching records in the main table, the other columns in the visual display as blank.
• This behavior occurs due to one-directional relationships or missing relationship data. To ensure your visual consistently displays accurate data regardless of the column order, verify that the relationships between tables are properly defined and that the filter direction is set correctly.
• When you initiate the visual with a column from a related table that has no matching records, the absence of these records can lead to the rest of the data not loading, resulting in blank values.
• Power BI visuals are heavily dependent on the established relationships and filter directions. If the filter direction is not properly set or if there are no matching keys between the tables, Power BI cannot propagate the filters, leading to blank results in the visual.

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

 

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!