Forum Discussion
Display columns from multiple table in a visual table
Hi rima_ch ,
If you apply fields from different tables on a visual, without creating any relationships between them, and if the applied Fields are not aggregated values or measures, you will get the following error message as in the screenshot below:
In this case you can solve the problem as follows.
1. Create relationships
Create and manage relationships in Power BI Desktop
Creating Table Visual with multiple tables
Handling MULTIPLE fact tables in Power BI
2. All the fields from the other tables are applied with aggregated values3. Create measure as you mentioned in your post
Return columns from multiple tables
Best Regards
Hi rima_ch ,
If you apply fields from different tables on a visual, without creating any relationships between them, and if the applied Fields are not aggregated values or measures, you will get the following error message as in the screenshot below:
In this case you can solve the problem as follows.
1. Create relationships
Create and manage relationships in Power BI Desktop
Creating Table Visual with multiple tables
Handling MULTIPLE fact tables in Power BI
2. All the fields from the other tables are applied with aggregated values
3. Create measure as you mentioned in your post
Return columns from multiple tables
Best Regards