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
Community Championrima_ch Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.