Forum Discussion
Display columns from multiple table in a visual table
Hello,
I was trying o display column from multiple tables that are related to each other but i keep geting Cant not display data in the visual, but when i put a measure in the visual (aggregate) everything works just fine could someone please tell me why .
Thank you.
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
2 Replies
rima_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.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
